Variance Percentage calculation

[msshihab1987]

Hi ,

I am trying to calculate the variance percentage by applying the following logic"

=IFERROR(I17/H17*100&"%","")" and the system is calculating the result perfectly ,

i wanted to limit the decimal point of the out put value into 2 digit.

I have tried the different option. can anyone tell what i have to change in the above logic to get two decimal point.

[former_member186338]

Use ROUND Excel function - it's absolutely basic ....

[JohnL]

Hi Shihab, what product are you using? Is that Analysis for Office or the EPM Add-In? Is this against BPC NW or BPC MS?

Please use the following primary tags going forward:

SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform

SAP BPC NW Community questions can now be found here:
https://answers.sap.com/questions/metadata/23125/sap-businessobjects-planning-and-consolidation-ver....

SAP BPC NW community blogs can now be found here: https://blogs.sap.com/sap/sap1/fin/73554900100700000805/01200615320800001016/

SAP BPC MS Community questions can now be found here:
https://answers.sap.com/questions/metadata/23126/sap-businessobjects-planning-and-consolidation-ver-...

SAP BPC MS community blogs can now be found here: https://blogs.sap.com/sap/sap1/fin/73554900100700000805/01200615320800000726/