Round Function

KBeltz

It would be great when using the Number of Decimal Places in the Round function if Anaplan rounded to the number of decimal places asked and it stayed rounded when going up the hierarchy. The summary is set to "SUM".

For example, I have five children members with a formula ROUND(Value $ * value %, 2) function. Each of the children correctly show two decimals. However, the parent has 12 decimals. Somehow, after summing, Anaplan added in 10 extra decimals that don't exist on the children..

(ROUND(Value, ROUND(Number to round [, Number of decimal places])

devrathahuja

Hi,
Have you tried using the "EXACT" syntax in the formula?

Below an example of using the same-

Value when using round(x,3) gives us 42.733000….4

Value when using round(x,nearest,exact) gives us 42.733

ArvillaKovacek

It's great, I have learned quite a lot of interesting tiny fishing formulas from functions in excel, thank you.