2 Replies Latest reply: Jan 23, 2013 5:56 AM by 952939 RSS

    how to add % in Data Form Cell

      I am working with version and going through some assignment of Data-Form. I am able to create data form both simple & composite data-form.
      Now I am going to add some sign with the data. I heard we can add +, +-, *, /, or %  along with a number.

      Now I have to add "%" sign to each cell in a particular column at the end of the each data .
      For that I have also Selected the Data type as well as Plane Type as a Percent for particular Member, but it does not affect to the data form cell or sign does not appeared in the cell.

      Could you tell me how is it possible to add this sign with data cell.
        • 1. Re: how to add % in Data Form Cell
          Have you set the evaluation order, Administration > Manage > Dimensions > Evaluation Order > Move the dimension with percentage member to the right.
          More info - http://docs.oracle.com/cd/E17236_01/epm.1112/hp_admin_11122/enum_dim.html
          To enter percentage values - http://docs.oracle.com/cd/E17236_01/epm.1112/hp_user_11122/ch05s01s05.html
          You may be also talking about where you can perform whatif analysis by using +, +–, *, /, or % before the value in a cell - http://docs.oracle.com/cd/E17236_01/epm.1112/planning_user_11122300/ch07s01s02.html


          • 2. Re: how to add % in Data Form Cell
            Hi John,

            Thanks for your reply. Now I got the exact work of member data type . it works successfully.

            I have one more question i.e. "%" i got in my cell of data-form.Now I want '+' and '-' sign instead of %. how it is possible. I have gone through the data type in member properties but not able to do it.

            what is the difference between datatype & Plant type(it includes +,-,%,/, etc.) of any member.
            I mean when should I use the Plan type values? I used the addition, percent,etc. but it should not affect anywhere.
            SO could you reply me for the same.