Ticket #29752
Question
I am doing a database calculation on a report and it is not working as I would expect. For one of my records, 0 minus 84 shows 0 (instead of -84) and 84 minus 0 shows 0 (instead of 84). Why is this happening?
Answer
Informed customer for this issue, those records that show '0' values as a result of arithmetic, are actually NULL values. Database arithmetic always gives a result of NULL when any of the arguments in the equation are NULL. To resolve this, advised him to edit the calculations one at a time and use the COALESCE() function.
Asked on November 27, 2019