Trying to sum the location quantity available for multiple locations as a formula on an item saved search (not to use summary type for the results) - tried formula numeric

(CASE WHEN {inventorylocation} = '1' THEN {locationquantityavailable} ELSE 0 END) + (CASE WHEN {inventorylocation} = '2' THEN {locationquantityavailable} ELSE 0 END)

however not adding together - any idea why? also the output I need is - as part of the criteria I've selected the multiple locations and currently they are displaying over multiple lines hence want to display as a sum on one line however it still appears as multiple...

answered in #general Also, please mention if you've cross-posting your question to other channels. Otherwise you can also share/forward your message to another channel