Anaplan natural rollup is not equal to sum of values from its children
Hi, fellow Anaplaners
I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values).
I have 2 line items here:
1. Commercial input is number formatted; no formula, is for planners to manual input forecast numbers
2. Final forecast CG is number formatted; formula is set to take commercial input if it is not zero, otherwise it takes statistically calculated forecast.
Some of the Commercial input will be blank due to no entries from the planners. But then when Anaplan sums up Commercial input values, the total will be different from the total of Final forecast CG which are supposed to be the same.
Please refer to the details in the attached Excel which is exported from the module. I am suspecting it might have something to do with those cells left BLANK in Commercial input but I couldn't really figure out the backend reason. Any insights will be greatly appreciated.