Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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.