Hi guys,
I wanted to see if you can maybe assist me with a formula which I am working on.
I have a saved search for transaction type: Sales Order
In this search I have the following formula which works great:
CASE WHEN {shipcountry} IN ('United States','Canada','Mexico') THEN 'North America' WHEN {shipcountry} IN ('Brazil','Chile','Guatemala','Dominican Republic','Argentina','Peru','Colombia','Puerto Rico','Costa Rica','Nicaragua','Belize','Honduras','Panama','Venezuela','Paraguay') THEN 'LATAM' WHEN {shipcountry} IN ('Austria','Belgium','Finland','France','Germany','Greece','Italy','Israel','Luxembourg','Netherlands','Spain','Sweden','United Kingdom') THEN 'Europe/Israel' WHEN {shipcountry} IN ('Turkey','Greece','Austria','China','Japan','Nigeria','South Korea','Australia','India','Russia') THEN ('New Geo') END
Basically this formula divides the shipping country into 4 different: Europa/Israel, New Geo, Norths America, Latin America.
Based on this formula I would like to add another layer of condition, not sure if possible so many conditions for one formula, I wasn't able to get it to work.
We need to have in one formula line the syntax above and on addition to that I would like to add the following conditions:
CASE WHEN {custcol_as_expecteddeliverydate}-{custbody_as_final_ml_ts} < 90 & 'New Geo' THEN 'IN SLA' ELSE 'Out of SLA'
CASE WHEN {custcol_as_expecteddeliverydate}-{custbody_as_final_ml_ts} < 14 & 'Europe/Israel' OR 'North America' THEN 'IN SLA' ELSE 'Out of SLA'
CASE WHEN {custcol_as_expecteddeliverydate}-{custbody_as_final_ml_ts} < 21 & 'LATAM' THEN 'IN SLA' ELSE 'Out of SLA'
{custcol_as_expecteddeliverydate} - This is custom date field in the SO
{custbody_as_final_ml_ts} - This custom date field in the SO
Thank you and please let me know if you have any questions or clarifications you require from me