Average % Complete calculation
HI all,
I need advice on the % average calculation at parent level.I’m finding a discrepancy in the average % indicated at parent level.
Here is the case, I’m finding a discrepancy in the average % indicated at parent level.
Here in the column % Complete, the Row 877-Test0 is having two indents Test 1 with 50% and Test 2 with 20%. Both averaging to 35% {(50+20)/2}. But at the Parent level Test0 its indicating 30% instead of 35%, this is calculated by Smartsheet.
Can you anyone advise how the average is coming as 30%?
Answers
-
Hi Vikas
I've had this problem in the past. The 30% result is based on the sum of Test 1: 2 daysx50%, and Test 2: 4 daysx20% divided by the total duration of Test 1+2 (6 days).
This happens when dependencies are enabled through the Gantt chart settings. If you disable dependencies, the avg formula should return a 35%.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!