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

I'm stumped on trying to get a weighted average on a saved search. My attempts so far have only produced an average of averages, which doesn't show what I'm looking for. Any ideas on how I could accomplish the following? I'll put examples in the sidebar thread -&gt;

image.png

Simplified raw data example in spreadsheet form

Saved Search Outputs 25% average defects. The weighted average would be 15 units / 50 total units or 30%.

You could try using sum formulas like in the following example in SuiteAnswers: <https://suiteanswers.custhelp.com/app/answers/detail/a_id/36895/loc/en_US>