This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm trying to calculate the difference in % between to Result columns in a Saved Search.

Essentially, I want it to always be a positive difference. So:

PO Amount = 25
Bill Amount = 30
Difference = 18.1818%

PO Amount = 30
Bill Amount = 25
Difference = 18.1818%

I'm trying to use this:

```(({netamount}-{billingtransaction.netamount})/(({netamount}+{billingtransaction.netamount})/2))*100```

but it's throwing an error

Try putting a NULLIF around the denominator: `NULLIF((({netamount}+{billingtransaction.netamount})/2),0))*100`

One thing you might have to do - is include criteria of billing.transaction fields amount is not equal to zero.

Sometimes NS doesn't explicitly call out the "possible divide by zero" error and just has a stroke.