I have an issue with a decimal showing up in a formula that's supposed to generate 0. Line Item A: 48250.4 Line Item B: 65810.4 Line Item ClearAB: A+B-45250.4-65810.4 yields 0 Line Item ClearABAlt: A+B-(45250.4+65810.4) yields 7.275957614183426E-12 All items have same numeric format.
ClearAB: A + B - 45250.4 - 65810.4 ClearABAlt: A + B - (45250.4 + 65810.4)you'd have
ClearAB: ROUND(A + B - 45250.4 - 65810.4, 2) ClearABAlt: ROUND(A + B - (45250.4 + 65810.4), 2)This will give you the expected zeroes.