CASE WHEN {createdfrom.fxamount} > 800 THEN CAS...
# general
a
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
any suggestions?
s
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.
a
@scottvonduhn ah got it.
thanks