Edit the search to include “Available Inventory” figures (Total Inventory minus Committed Inventory)

Need to determine the value for “Available Inventory” in saved search. The value has been obtained from Total Inventory minus Committed Inventory

By using the NVL Function, we can insert a Formula in saved search field to retrieve a second value if the first is blank, the result value is blank. In saved search, we can use NVL function in formula

ROUND({quantityonhand}{averagecost},2)- ROUND(NVL({quantitycommitted}{averagecost}, 0), 2)