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 to classify items sold and assign letter to them based on overall total %
Trying to classify our items sold with letters A,B,C,D based off of which items added together make up the most sales. Here's how I'm trying to classify them:
A – Items that represent 50% of last 365 days sales
B – Items that represent from 50% to 75% of last 365 days sales
C – Items that represent the remainder of belts in which total sales per item was above $100
D – Items that represent items sold in which total sales per item were under $100
How would one go about doing something like this from within a saved search? I can get it done in excel, but from within NetSuite is the challenging part.