Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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?