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!
Saved Search using Ranges / Bands
I would like to create a saved search to help us calculate commissions on sales.
We have ranges with a different percentages, but the difficulty I'm having is that it's sliding scale - not straight.
So if the bands are say 0-1000 = 1%, and then 1001 and above is 2%, and the sales volume is 1,500, the total would be 20 (1000*1%) + (500 *2%). Not 1500 * 2%.
We have an Excel spreadsheet using SUMPRODUCT formula but I'm not sure if this can be re-created in NetSuite.
I would like one version of the data instead of having to populate this spreadsheet.
Thanks for any help or guidance.