Valid PSA-Sysadmin Dumps shared by ExamDiscuss.com for Helping Passing PSA-Sysadmin Exam! ExamDiscuss.com now offer the newest PSA-Sysadmin exam dumps, the ExamDiscuss.com PSA-Sysadmin exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com PSA-Sysadmin dumps with Test Engine here:
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%?
Correct Answer: B
* Understanding the Issue * The report shows80% utilization per monthbut160% over two months. * This happens becausepercentages are summed instead of averagedin the subtotal. * Solution: Use a Summary Level Formula (Correct - Option B) * Step 1:Open theUtilization Reportin Salesforce Reports. * Step 2:ClickEdit Report. * Step 3:Add aSummary Level Formulainstead of summing percentages. * Step 4:Define the formula: Utilization Subtotal=SUM(Billed Hours)SUM(Available Hours)\text {Utilization Subtotal} = \frac{\text{SUM(Billed Hours)}}{\text{SUM(Available Hours)}} Utilization Subtotal=SUM(Available Hours)SUM(Billed Hours) * Step 5:Save and rerun the report to validate the fix. * Why Not Other Options? * Option A (Adjusting Work Calendar): The work calendar controls available hours but does not fix subtotal errors. * Option C (Target Utilization Approach - Weighted): This setting affects calculation logic but does not solve subtotal summation errors. * PSA Sys Admin Essentials Student Guide Fall 20 (2).pdf, Page 114. References: