How to Convert a NetSuite Percentage Field into a Decimal/Integer

One of our clients required the “Probability” field native to the Opportunity record in NetSuite to be shown as a decimal integer rather than a percentage for reporting reasons.

However, because the “Probability” field is native, it cannot be changed. Additionally, the company needed the probability to match the specific percentages respective to each “Stage” (custom field) of the customer status on the Opportunity (0%, 20%, 50%…).

Solution Via a NetSuite Workflow

We easily achieved both of these requirements for our customer using a Workflow in NetSuite. Here's how we set up the workflow to accomplish this.

• The NetSuite workflow sets the specific Probability percentage based on whatever Stage is selected (as a condition).
• On record submission, a custom field named “Opportunity Probability Integer” (the custom field is set as a decimal format) uses the percentage set in the Probability field, thus converting it into an integer.
• The Probability and Opportunity Probability Integer fields were also disabled, so that the workflow may not be interrupted by a user or otherwise manipulated.

View of workflow actions to set probabilities and probability integer, and disable field editing.

View on NetSuite opportunity record of the end result of workflow with corresponding fields set and matching.

If your company has a similar need to convert a native NetSuite percentage field to a decimal/integer, implementing the solution outlined above should meet this need! If you need assistance with this process or are encountering errors, contact our team for support!

Related Article: Formatting Strings as Currency | SuiteCommerce

Got stuck on a step in this article?

We like to update our blogs and articles to make sure they help resolve any troubleshooting difficulties you are having. Sometimes, there is a related feature to enable or a field to fill out that we miss during the instructions. If this article didn't resolve the issue, please use the chat and let us know so that we can update this article!

Oracle NetSuite Alliance Partner & Commerce Partner

If you have general questions about NetSuite or more specific questions about how our team can support your business, contact us! Anchor Group is a certified Oracle NetSuite Alliance Partner and Commerce Partner equipped to handle all kinds of NetSuite and SuiteCommerce projects, large or small.