CASE WHEN ((({item.locationquantityonorder}) + ({item.locationquantityavailable}) - ({item.locationquantitybackordered})) < 0) THEN (({item.locationquantityonorder}) + ({item.locationquantityavailable}) - ({item.locationquantitybackordered})) END