Mar 15, 2023 06:19 PM
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.
Mar 16, 2023 12:50 AM - edited Mar 16, 2023 12:53 AM
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
Mar 16, 2023 05:02 AM
Yes, I checked that. Doesn't look like it is a precision problem.
Mar 17, 2023 01:40 AM
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