I have a report with two bucket groupings: day of week & Utilized/Not Utilized. I want to do a summary-level formula to give me the percentage of Utilized vs Not Utilized within each day. However, I can only get a percentage of Utilized across all days and Not Utilized across all days. Or, I can have the Subtotal of those combined with a percentage comparing Sun-Sat.
What I would like to see, for example, is for Thursday, if Not Utilized is 1 and Utilized is 3, that Not Utilized would have 25% by it, and Utilized 75%.
My formula is:
RowCount/PARENTGROUPVAL(RowCount, CDF1, GRAND_SUMMARY)
CDF1 is my Group Rows field
Grouping by Row: CDF1
Grouping by Column: Utilization (doesn't work when I do Day of Week)
Is this possible?
You can see in the screenshot, third row, where I have a 55.6% & a 44.4%. These should both be 100% for what I want, since there is 0 for Utilized on the given day.
PS. To eliminate Divide by Zero #Error results use an "exit" like this
IF(
PARENTGROUPVAL(RowCount, Opportunity.Do_you_owe_SteveMo_a_beer__c, Opportunity.Close_Date_Day_of_the_Week__c) = 0,
0,
RowCount
/
PARENTGROUPVAL(RowCount, Opportunity.Do_you_owe_SteveMo_a_beer__c, Opportunity.Close_Date_Day_of_the_Week__c)
)
