Anaplan calculates 0.000000000000000111022 value but it should be zero.
Can someone help me or point me to if there are already discussion around this topic?
In Anaplan, I am doing a moving sum prior 11 months and it looks like it returns a 0. As seen in the screenshot for Sep 23. But when I copy and paste the value into Excel, it is showing 0.000000000000000111022.
Copied SEPT 23 into in Excel show a nonzero value:
What is causing this and how can Fix this issue?
I would like to understand why first.
I think I can simply fix it by adding to the formula, highlighted in yellow in screenshot below, but I would like to understand why it is not calculating correctly a zero, when it looks like a zero, "-".