Help

"-0" in the formula result

Topic Labels: Formulas
540 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mihail
4 - Data Explorer
4 - Data Explorer

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.

 

Mihail_0-1678929485130.png

 

3 Replies 3
TheTimeSavingCo
17 - Neptune
17 - Neptune

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:

Screenshot 2023-03-16 at 3.50.21 PM.png

Link to base

Can't say for sure though

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

Mihail_0-1678968067222.png

 

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

Screenshot 2023-03-17 at 4.38.09 PM.png

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