Deducting Qty Committed from Qty on Hand using a Formula leaves some fields in Formula Column empty

 

1) Navigate to List > Search > Saved Searches > New > Item

2) Criteria tab > Type = Inventory Item

3) Results tab > Add Formula (Numeric) > Formula: {quantityonhand}-{quantitycommitted}

4) Preview

Actual Results: If field: Quantity on Hand or Quantity Committed has no value, the Formula column field is empty.

To resolve this, insert a NVL function: nvl({quantityonhand},0)-nvl({quantitycommitted},0)