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.