Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Sum of two case statements for item quantity?
So I have two simple case statements that help me see inventory by location. When separating the formulas, I can see the proper numbers in each column.
Formula (Numeric) --> CASE WHEN {inventorylocation.namenohierarchy}= 'Los Angeles' THEN {locationquantityavailable} END
Formula (Numeric) --> CASE WHEN {inventorylocation.namenohierarchy}= 'Phoenix' THEN {locationquantityavailable} END
But when I try to add the two case statements together, I only get a blank value.
(CASE WHEN {inventorylocation.namenohierarchy}= 'Los Angeles' THEN {locationquantityavailable} END) + (CASE WHEN {inventorylocation.namenohierarchy}= 'Phoenix' THEN {locationquantityavailable} END)
In case you are wondering why I do not pull the "Available" column, we have additional warehouses under the one subsidiary that I need to exclude that would have otherwise been included when searching the "Available" field.