Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Formula for % based difference between two values
We have a Purchase Order approval workflow that allows users to resubmit changes after approval that will be subject to re-approval if there is GL-impact. We have a custom field that stores the original approved PO total amount and another that stores the edited PO total amount. We have a transition that makes sure these two field values are equal in the condition, then it can transition back to Approved state.
We are looking to implement a 5% change threshold for this workflow so that any changes below 5% will go back to approval state as well. Can someone please help me with a condition formula that will implement this?
0