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.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives