Skip to Content
avatar image
Former Member

Excel KF

Hi Experts

I need to change the value for one KF to % on the Excel in one template

does any can help me with some ideas?

Jorge

Best Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 24, 2016 at 07:25 PM

    Hi Jorge,

    This can be easily achieved from EPM formatting sheet.

    Go to Dimension Member / Property Formatting -> Row (priority to row format should be check by default in pre delivered templates) -> Add Member Property -> Select Key Figures under Dimension -> Select specific Key Figure on the right screen -> OK

    Once the Key Figure appears under Formatting on Specific Member / Property right click on the cell from column F (Data) where 10.000 is -> Format Cell -> Number -> Percentage (excel formatting)

    Then you can double click on the cell next to the right and select Number Format.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 25, 2016 at 02:46 PM

    Hi Alecsandra

    Thank you very much for your help i can do the change

    Jorge

    Saludos

    Best Regards

    Add comment
    10|10000 characters needed characters exceeded