Skip to main content

"-0" in the formula result

  • March 16, 2023
  • 3 replies
  • 16 views

Forum|alt.badge.img+1

Is there any reason for -0 in the result of the simple formula as Paid-Shipped? Is it interesting, as it shows only in one row.

 

 

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

The last time this happened to me it was because it wasn't actually a 0 and the decimal place is being cut off, like so:

Link to base

Can't say for sure though


Forum|alt.badge.img+1
  • Author
  • New Participant
  • 1 reply
  • March 16, 2023

The last time this happened to me it was because it wasn't actually a 0 and the decimal place is being cut off, like so:

Link to base

Can't say for sure though


Yes, I checked that. Doesn't look like it is a precision problem.

 


TheTimeSavingCo
Forum|alt.badge.img+31

Yes, I checked that. Doesn't look like it is a precision problem.

 


Interesting!  Could you try adding a `ROUND()` to the "Balance" field and see whether it goes away?

The formula I used above was:

ROUND(0 - Number)

 And "Number" has a value of 0.000000001, which shows as 0s in the screenshot

If the ROUND works, it might be due to floating points, but I would open a support ticket to be certain