Add a Column to Show the Total Location On Hand, Location In Transit and Location On Order per Row

1. Navigate to Lists > Search > Saved Searches > New > Item.
2. On the Criteria subtab, enter specific filters depending on user’s preference.
3. On the Results subtab, enter the following:

• Type
• Name
• Description
• Location On Hand
• Location In Transit
• Location On Order

4. To sum the Location On Hand, Location In Transit and Location On Order per row, add a Formula (Numeric) on the Results subtab. Formula as follows:

COALESCE({locationquantityonhand}, 0) + COALESCE({locationquantityintransit}, 0) + COALESCE({locationquantityonorder}, 0)

5. Hit Save and Run.