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

    how to add % in Data Form Cell

    952939
      Hi,
      I am working with version 11.1.2.2 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
          JohnGoodwin
          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

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: how to add % in Data Form Cell
            952939
            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.

            Thanks