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.
Obviously the next step would be the Profit margin % based on that result.