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!
NSAW Grand Total
Hello!
I am using NSAW and created a pivot table.
The purpose is to calculate commissions for sales reps.
I created a calculated field (item.custcol_commrate * transactionline.netamount)
Note, this isn't the exact formula. Just showing the detail of what I am calculating.
When I create a table, the calculation is correct and shows my commission due for that line.
When I make it into a pivot table, my totals go into the trillions.
How do I properly sum this calculated field? Happy to provide more details.