I'm trying to do a simple adding together of 2 values, but if one of the values is empty the calculation doesn't work. Is there a way to treat empty values as 0.

Comments

marcus178’s picture

marcus178 commented
Title: Does work with empty value » Does not work with empty value
marcus178’s picture

marcus178 commented

The following seems to correct the problem.

IFNULL(%uc_order_products_qty_sold.sum_qty_sold,0)

karens’s picture

karens commented
Issue summary: View changes
Status: Active » Closed (won't fix)

The D6 version is no longer supported.