Would someone explain why Anaplan is giving me a number 5x larger than the number I am dividing when my calculation takes the first number (4,221.43) and divides it by 0? I would assume that it would be 0 or a NaN. Not something as large as the last number.
have you checked that the amount is not displayed as 0 because of the line item format but it has some decimals hidden? If it is an unexpected amount because of an allocation you can use the ROUND function.
Here is an export of the blueprint. The item we are looking at that is off is the budget per tx line item and the line item subset we are looking at is 6603. Since that is not an exception in the formula then the calculation is just taking the budget(4221.43)/budgeted tx (0).
It looks like the round formula worked when I added it to the source. The totals in the hierarchy are functioning as you would expect, it is just this one case. Could you explain why something that is showing as a true 0 would be causing this issue, but when the round function is applied Anaplan starts to treat it like a 0?
I tried to reproduce this, but could not. But i observed the decimals are not handled well when it becomes too small. Look at the summary for B in the grid and its actual value on the top right corner, i dont understand why Anaplan put 1 at the last decimal.