any idea on how to pull an Item’s available inventory at a specific location using Formula search? I am trying to pull each location’s available quantity into different columns instead of having it make new lines for every location on an item search

We use formula of

CASE WHEN {inventorylocation} = 'LOCATION' THEN {locationquantityonhand} ELSE 0 END

And Group by item name/item id and set this formula column as MAX

ah the grouping is what got me. that will do it. thanks!