This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Any suggestions? We have customers that when ordering a quantity  above a threshold they pay a lower price per selling unit. Taking an Average on a result column isn't weighted and I'm having a tough time seeing how to make this work given what I see available to me in a saved search

Formula(Currency) - from there you can run the calculations that you would need to do. I don't use weighted averages, but if the data is in NS, you can most likely put it into a formula.

How would you calculate it outside of NetSuite?

take the sum of the amount and divide by  Sum of the quantityuom

I can get the sum of quantityuom and sum of amount in separate columns then just do the extra step in excel but was hoping to do it in NetSuite.

should be able to do {quantityuom}/{amount} in a formula field, or some variation of that