Highlighted
Expert

Addition and Subtraction results can appear inaccurate when working with decimals

This item has been identified as an outstanding known issue. 

Issue

If adding/subtracting decimal values then outputs can appear inaccurate.

For example; if you have 4 line items (a, b, c and d) and d has the formula "a-b-c", then setting a=1.01, b=1.005 and c=0.005 should mean d=0 but instead d=1.1535911115245767E-16.

 

---

Internal Reference: CALC-1467