0

Zero negative result in Formula

Hi!

I have two fields:

Total Invoice

Amount Paid

 

I have a function that calculates the difference

Total Invoice - Amount Paid

 

If the result is 0 the formula gives me a result -0.00 €. In practice gives me a zero negative result.

Why?

1 reply

null
    • Web_Namer
    • 1 yr ago
    • Reported - view

    I see what’s going on.

    In practice, the Total Invoice is a number calculated and rounded only to display.

    So Total Invoice appears 100.00 but actually it is 99.99685584. 

    Instead the Amount Paid number is really 100,00. 

    The difference between the two is a very small negative number that rounded to the display appears only as a negative zero.

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 1Replies
  • 46Views
  • 1 Following