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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Percentage comparison of two formula values
I have created a custom transaction search filtered to Invoices and Credit Memos.
Using a Currency Formula of:
(case when {type} = 'Invoice' then nvl({amount},'0')else 0 end)
I have been able to retrieve just the invoice amount in my first column.
Using a Currency Formula of:
(case when {type} = 'Credit Memo' then nvl(({amount}*-1),'0')else 0 end)
I am able to convert the credit amount to a positive number in my second column.
In my third column I would like to compare the percentage of credits issued to the amounts invoiced. Using a Percentage Formula I am getting Divide By Zero errors in this column when I use:
0