New to search formulas and trying to add on hand inventory by location to an existing item search using a formula. Able to use {quantityonhand} to pull all on hand inventory but unable to show just a single location. Anyone have any thoughts to what is wrong with this statement? CASE WHEN {location} = 'FBA' THEN {quantityonhand} else 0 END