Try: `CASE WHEN {preferredstocklevel} = 0 THEN 'SP...
# suiteanalyticsj
jcribb
02/01/2018, 3:12 PMTry:
CASE WHEN {preferredstocklevel} = 0 THEN 'SPECIAL ORDER' WHEN {preferredstocklevel} <= 5 THEN 'LOW STOCK' ELSE 'STOCKED' END