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