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!
Trying to get to the average selling price on sales orders on a saved Search
Hello,
I am trying to create a search For a sublist that will calculate the average selling price of an item based on Sum of total amount ( on all related sales orders) /total number of units sold.
I am feeling every bit the novice that I am, and have spent way to much time trying to search for the answer.
I have started with a transaction search and got the average of the rate , but not the average of the total units sold.
I know there has to be an easy formula out there that i am missing that will return the result.