cancel
Showing results for 
Search instead for 
Did you mean: 

Excel KF

former_member235875
Active Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Alecsandra
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

Answers (1)

Answers (1)

former_member235875
Active Participant
0 Kudos

Hi Alecsandra

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

Jorge

Saludos

Best Regards