i am trying to add business days only to my saved ...
# suiteanalytics
d
i am trying to add business days only to my saved search, how do i go about it. this is my search case when {custbody_payment_terms}= '45 Days from Delivery' then {custcol2}+45 when {custbody_payment_terms}= '50% Business Days Prior to US Port Arrival' then {custcol2}+70when {custbody_payment_terms}= '20% Upon PO Acceptance' then {custcol2}+90when {custbody_payment_terms}= '60% Upon PO Acceptance' then {custcol1}-5when {custbody_payment_terms}= '371 days' then {custcol2}+371END
a
Have to add case when statements to validate what day of the week is the result of your formulas then update them so dates don't land on weekends
d
Case to again case statements. Man oh man