I have a formula CASE WHEN {createdfrom.fxamount} ...
# generala
Amtoj
11/19/2021, 11:46 PMI have a formula CASE WHEN {createdfrom.fxamount} > 800 THEN ‘DHL EXPRESS’ ELSE {createdfrom.shipmethod} END
Also need to add another condition to the first case that the “{shipcountrycode} = US” so essentially if fxamount is more than 800 and the ship country code is US then ‘DHL Express’
Any suggestions????
e
ericbirdsall
11/19/2021, 11:52 PMCASE WHEN {createdfrom.fxamount} > 800 THEN CASE WHEN {shipcountrycode} = 'US' THEN ‘DHL EXPRESS’ END ELSE {createdfrom.shipmethod} END
ericbirdsall
11/19/2021, 11:53 PMYou can nest CASE statements like this
a
Amtoj
11/19/2021, 11:53 PMthank you; let me try
e
ericbirdsall
11/19/2021, 11:53 PMericbirdsall
11/19/2021, 11:53 PMThis is very good reference for Saved Search things - I highly recommend checking it out
a
Amtoj
11/19/2021, 11:54 PMthanks - I just tried your suggestion - dint work but let me see 🙂
e
ericbirdsall
11/19/2021, 11:54 PMAlso - if you copy and paste that formula make sure that all of the Single Quote symbols are actually Single Quote symbols
ericbirdsall
11/19/2021, 11:55 PMCASE WHEN {createdfrom.fxamount} > 800 THEN CASE WHEN {shipcountrycode} = 'US' THEN 'DHL EXPRESS' END ELSE {createdfrom.shipmethod} END
ericbirdsall
11/19/2021, 11:55 PMTry this (though it looks the same, I replaced the weird quotes with single quotes)
a
Amtoj
11/19/2021, 11:57 PMgot it, basically I need a Case where both conditions for the fxamount and shipcode need to be true collectively
Amtoj
11/19/2021, 11:58 PMcase when{item.custitem_vertical}=‘AEC’ and {item.custitem_product_type}IN(‘Software’,‘Fee’) then {amount}end
I am guessing something of this type??
Amtoj
11/20/2021, 12:00 AM@ericbirdsall nevermind
Amtoj
11/20/2021, 12:00 AMyour formula worked
Amtoj
11/20/2021, 12:00 AMthanks
e
ericbirdsall
11/20/2021, 12:01 AMThere are a few ways to handle these. You can either nest statements like the formula I sent. Or you can use AND in your CASE statements like the example you replied with
ericbirdsall
11/20/2021, 12:02 AMHonestly using AND is more readable, and I'd probably do it that way
a
Amtoj
11/20/2021, 12:03 AMthanks yours worked 🙂 Cheers
6 Views