Ricardo
05/20/2020, 5:29 PMCASE WHEN {custitemquantity_free_ship_customer} =1 THEN 'ShipsFree' ELSE {custitemquantity_free_ship_customer} END
if I pull it by itself, it works fine, but if I try to do a Case/When statement on it, it fails as "Invalid Expression". Does anyone have any insight?Merik Ducker
05/20/2020, 5:45 PMGregory Jones
05/20/2020, 5:58 PMELSE TO_CHAR({custitemquantity_free_ship_customer})
Ricardo
05/20/2020, 6:02 PMCASE WHEN ({custitemquantity_free_ship_customer} = '1') THEN 'ShipsFree' ELSE {custitemquantity_free_ship_customer} END
For whatever reason... parenthesis helped it work along with putting the value in quotes.Ricardo
05/20/2020, 6:03 PMCASE WHEN ({custitemquantity_free_ship_customer} = '1') THEN 'ShipsFree' ELSE ( CASE WHEN ({custitemquantity_free_ship_customer} >= '2') THEN CONCAT({custitemquantity_free_ship_customer}, 'SqFtShipsFree') ELSE ' ' END ) END