MENU
A manager was looking at utilization for a resource for the last two months. The resource was identified as 80% utilized for each month, but the subtotal section showed 160% for the user for that same two month period.
How can the report be fixed to show 80% instead of 160%?
Suggested Answer: B
Get Premium PSA-Sysadmin Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
31 comments · newest first
RO
Rodrigo
10 months ago
Adjusting the work calendar could help too, but not sure it’s the best fix.
LI
Lisandra
11 months ago
Totally agree with Sarah, that subtotal needs fixing.
AN
Angella
11 months ago
Wait, how can you get over 100% utilization?
MA
Magdalene
11 months ago
I think option B makes the most sense!
RE
Rebeca
11 months ago
Seems like a classic case of double counting.
LI
Lilli
12 months ago
I think I read that subtotals can be misleading if they just sum percentages. So, option B sounds like it could fix the issue, but I’m not 100% sure.
BI
Billye
12 months ago
I practiced a similar question where we had to adjust settings for utilization. I feel like option C could be relevant, but I’m not confident.
KA
Katie
12 months ago
I'm not entirely sure, but I think adjusting the work calendar could help. It seems like it might change how the utilization is calculated.
LE
Lenny
1 year ago
I remember something about how subtotals can sometimes just add up percentages instead of averaging them. Maybe option B is the right choice?
AL
Aleshia
1 year ago
I'm feeling pretty confident about this one. The key is to adjust the report settings to calculate the utilization correctly. Option C, setting the Utilization setting to 'Weighted', should do the trick.
DA
Dallas
1 year ago
Okay, I've got this. The issue is that the subtotal is summing the utilization instead of calculating the average. Option B to create a summary level formula is definitely the right fix here.
ER
Erick
1 year ago
Hmm, I'm a bit confused by this one. The utilization is showing as 80% for each month, but the subtotal is 160%. I'll need to think through this carefully to figure out the best approach.
VE
Veronica
1 year ago
This seems like a straightforward issue with the report calculation. I think option B, creating a summary level formula, is the way to go here.
HU
Hubert
1 year ago
Haha, I bet the manager is scratching their head over this one. Maybe they need to hire a wizard to fix the report!
CH
Chan
1 year ago
C) Set the 'Utilization' setting for Target Utilization Approach to 'Weighted'
ON
Onita
1 year ago
B) Create a Summary Level formula so the subtotal is calculated and not summed
AJ
Aja
1 year ago
A) Adjust the Resource's work calendar to 40 hours and refresh the report
CR
Cristal
1 year ago
Ooh, the 'Weighted' utilization setting could be the way to go. That might help consolidate the numbers correctly.
TI
Tish
1 year ago
Annett: Agreed. Let's update the setting and refresh the report to check the results.
IL
Ilene
1 year ago
User 3: Let's give it a try and see if it resolves the issue.
AN
Annett
1 year ago
User 2: That sounds like a good idea. It should help fix the report.
JA
Jacquline
1 year ago
User 1: I think we should go with option C and set the 'Utilization' setting to 'Weighted'.
LY
Lynda
1 year ago
Hmm, I'm not sure the work calendar adjustment would fix this. Seems like a problem with the way the subtotal is being calculated.
LO
Lorita
2 years ago
I'm not sure about that, maybe creating a Summary Level formula could also work to correct the subtotal calculation.
AR
Arlyne
2 years ago
This question is really tricky! I think the key is to understand how the utilization calculation is being done. The report seems to be double-counting the resource's time.
SH
Shonda
1 year ago
I agree, it seems like the report is counting the resource's time twice.
YO
Yoko
1 year ago
C) Set the 'Utilization' setting for Target Utilization Approach to 'Weighted'
MA
Mammie
1 year ago
B) Create a Summary Level formula so the subtotal is calculated and not summed
BU
Buddy
1 year ago
A) Adjust the Resource's work calendar to 40 hours and refresh the report
SA
Salley
2 years ago
I agree with Tanja, that seems like the most logical solution to fix the report.
TA
Tanja
2 years ago
I think we should adjust the resource's work calendar to 40 hours and refresh the report.