Hello! I am trying to show on my report the percentage of each reason by each week. I am using the following formula:
RowCount / PARENTGROUPVAL(RowCount,Case.Handover_Outcome_Reason__c, CLOSED_DATE)
However, all the percentages are showing up as 100% if the value was 1 or more. What am I doing wrong with the formula?
답변 2개
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Madison,
Are you trying to do this?
RowCount / PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, CLOSED_DATE)
Since you're trying to find the proportion from the total of the row, you need that value instead of Case.Handover_Outcome_Reason__c. This is comprised in the RowCount, depending on where you display the formula
