CASE WHEN {createdfrom.fxamount} > 800 THEN CASE WHEN {shipcountrycode} = 'US' THEN 'DHL EXPRESS' END ELSE {shipmethod} END
The formula doesnt seems to be working, the {shipmethod} has a value when in a separate but throws a blank value when in the formula
Amtoj
03/17/2022, 7:39 PM
any suggestions?
s
scottvonduhn
03/17/2022, 8:04 PM
There are two nested case statements here, but the inner case statement has no else, so if shipcountrycode is not US, there will be no output.