We use a secondary address for Vendors on our PO in specific scenarios. Because of this we have setup some saved searches with an NVL2 formula to pull the secondary address if its being used in place of the billing address.
For the state results we use this formula:NVL2({custbody_vr_removal_add_addressee},{custbody_vr_removal_add_state},{billstate})
The issue we are having is that when the results are returned, the {custbody_vr_removal_add_state} variable will return the full name, New York, and {billstate} will return NY. This makes it difficult to parse the data by state alone.
I have found a Suite Answers page that gives me the decode formula to return the full name for {billstate}. https://suiteanswers.custhelp.com/app/answers/detail/a_id/32730/loc/en_US
This works correctly as its own column on the saved search. But what I really need is to nest this in with the NVL2 so that it will decode the {billstate} result only.
The logic on this would be along these lines: NVL2({custbody_vr_removal_add_addressee},{custbody_vr_removal_add_state}, DECODE{billstate})
I am struggling with finding the correct syntax to get this to work.
Thank you for your help!