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

[former_member418006]

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

[former_member186338]

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

Also screenshot of local member setup...