Skip to Content

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

Apr 13, 2017 at 07:38 PM


avatar image

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


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,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Apr 13, 2017 at 08:13 PM

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

Also screenshot of local member setup...

10 |10000 characters needed characters left characters exceeded