Addition and Subtraction results can appear inaccurate when working with decimals

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