Skip to Content

How to get multiple calculation in single column? (SAP BPC EPM)

Hi Experts,

I have a requirement in BPC EPM for showing decimals in specific values in a column and for other values which are in percentage need not be shown in decimals.

Please find below examples for better understanding :

Dimension Budget Actual Var Var % A

BC

10 7 3 30 PQR 20 13 7 35 XYZ 30% 25% 5% 17% *100

While creating Var % we have considered the formulae = Budget - Actual/Budget*100 (Values highlighted in Italic)

But While calculating Var % for XYZ Dimension it is also getting multiplied by 100 which is not needed. So, our requirement is to show different calculation for Dimension ABC,PQR & different for Dimension XYZ in same column.

So please let us know how can we achieve the above requirement, Any inputs or help for the same will be appreciated.

Thanks & Regards,

Badal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 13, 2017 at 08:13 PM

    Please use screenshot of the report! Your question is unreadable!

    Also screenshot of local member setup...

    Add comment
    10|10000 characters needed characters exceeded