Formula for Finding the back ordered quantity in a transaction Saved search.

Scenario:

In a transaction saved search if we want to get the number of back ordered quantity in the search, we can use this formula as formula text in the results column.

Formula

{quantity}-nvl({quantityshiprecv},0)-nvl({quantitycommitted},0)