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.
Page 1 / 1
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:
Can't say for sure though
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:
Can't say for sure though
Yes, I checked that. Doesn't look like it is a precision problem.
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.