Saved search showing quantity available summed for multiple locations

AI generated answer (using internal Slack threads):

To create a saved search that shows the quantity available summed for multiple locations, you can use a formula in the saved search. However, it seems like you're having trouble with the formula not adding together. This could be due to the way the formula is structured. One of the users suggested using an advanced, unsupported method that requires knowledge of SQL queries. The method involves using analytic functions in formulas. Here is the suggested formula:

SUM/*comment*/(CASE WHEN {inventorylocation} IN (1,2) THEN {locationquantityavailable} END) OVER (PARTITION BY {internalid})

This formula sums the location quantity available for the specified inventory locations (1 and 2 in this case) and partitions the results by the internal ID of the item. This should give you a sum of the quantity available for each item across the specified locations. Please note that this method is advanced and unsupported, so use it with caution. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******