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.

praveenvenkatesh

Hi @devrathahuja ,

You are right. By mentioning the second argument in ROUND function as 3, you can round the result to three decimal places, then by using the third argument as NEAREST you can round the value of the Number or decimal place, and finally with the Rounding method as EXACT, ROUND function performs additional processing to minimize the effect of floating point error. So you get the value as 42.733.