@Pauline Joy Cac-Oracle , First off I just want to say thank you for assisting on this. Everytime you guys have been so helpful! I do have one question remaining on this IF Statement. I went through and configured manage translations as you have outlined and the code works great in tandem. One issue is that when a non…

@Pauline Joy Cac-Oracle Thank you so much for helping with this!

@Ivy Lopez-Oracle yes my criteria matches. Still get errors. I've just been trying small tweaks to the string as I believe this will do the trick. Not totally understanding why it's not giving the result.

I modified with the NULLIF (SUM(CASE WHEN ({memo} LIKE '%Customs and Duty-LC%') THEN {amount} else 0 END+CASE WHEN ({memo} LIKE '%Freight-LC%') THEN {amount} else 0 END+CASE WHEN ({memo} LIKE '%Agent Fee-LC%') THEN {amount} else 0 END))/MAX(NULLIF({quantity},0)) I get 0.00

I think were close: I get an error There is a divide by zero error in this search. It may be an error with a formula you have used. Please retry without the formula(s). If an error still occurs, please file with Customer Support. If it does not, please correct your formula. Typically that consists of taking the denominator…

Thanks Jack! Works like a charm. Kyle

Jack, This was great! Thanks for the help. I do have one last question. How could i alter the string to keep the decimal value formatting consistent, so to prevent the 15% from dropping the zero's and coming in similar to the 14.99%? Kyle

I like the result on the 14.99%, brings onto one line, i guess one issue and I did not identify it in the original ask was this account brings in Discounts in both Percents and Dollars, so this second discount was originally displayed as: Could you think of a tweak to this if else statement to incorporate a discount that…

Jack, You are amazing! I don't suppose you'd be open to helping me configure a script that is causing some errors? Kyle

Just trying to shorten this but still allow other Un Price (rate) amounts to come in with $ signs as well such as the Return Fee.

@Pauline Joy Cac-Oracle Thank you!

You're the best! Thanks!

Think we are good, we ended up using {applyingtransaction.datecreated}-{systemnotes.date} Thank you!

And to clarify, they just would like the difference of that custom box being checked on the SO to the IF creation date.

So it is a custom field check box on the SO "Already sent to 3PL" and the related record is an IF.

@Mikko De La Fuente-Oracle I've been well, thank you for asking and as always thank you for taking the time to look into this. Kyle

@Herdi Rana-Oracle Helpful as always! Got me on the right track! And the SA article appears to be the one I have been looking for! Kyle

Hey @Herdi Rana-Oracle Ok, we are definitely looking into this. Could it be possible to workflow this and null that column on certain criteria or script? Kyle

Thank you!

@"Pauline Joy Cac-Oracle" thank you so much! This site is incredible btw! 

subrecord<span class="punctuation token">.</span><span class="token function">setFieldValue</span><span class="punctuation token">(</span><span class="string token">'country'</span><span class="punctuation token">,</span> <span class="string token">'US'</span><span class="punctuation token">)</span><span…

Thank you so much!

Thanks Micah!