Calculate the difference between two fields in a saved search in case a field has null value.

Formula

NVL({field1}, ‘0’)-NVL({field2}, ‘0’)

Function = NVL

Syntax = NVL(expr1, expr2)

Short Description = lets you replace null with the second parameter.

Example = NVL({quantity},’0′)