Weighted Averages for Several Rows
Steve Holt
✭✭
Hi,
I'm building a tracker that will record scores for different regions that will receive inputs once a quarter. I need to roll each region up to provide a single score for each quarter. Since each region might have a lot or very few projects underway in a quarter I need to weight the overall average score to reflect that.
Simply using Summarise in a report won't work, since that will just give me a simple average of the scores (at least I think that's the case, not 100% sure). And I can't seem to work out if a Parent/Child record structure might work.
Does anyone have any advice?
Thanks
Answers
-
Have you tried =AVGW?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives