https://netsuiteprofessionals.com logo
j

jokell

02/24/2017, 5:38 PM
You have a lot of parentheses in there. Try this:
CASE WHEN ({item.locationquantityonorder} + {item.locationquantityavailable} - {item.locationquantitybackordered}) < 0 THEN {item.locationquantityonorder} + {item.locationquantityavailable} - {item.locationquantitybackordered} END