Percentile in CR9 Group Footer 1

[rkm500]

I am truing to get the percentage of Total in a subgroup as follows:


Provider Total Admitted Disch AMA

John 12 3/11% 5/18% 4/15%
Mary 5 2/7% 3/11% 0/
Paul 10 5/18% 3/11% 2/7%

TOTAL: 27

My objective is to calculate the percentage for each category of the total:

Like in first row second col, Admitted 3 should have percent of total of 27 which is about 11%.

The fields Admitted, Discharge and AMA are calculated fields.

I am not able to get the Percentage of these numbers against the Grand Total.

Any help will be appreciated.

Thank you.

RKM

 

[lbass]

You need to share the contents of each of your "calculated fields," by which I assume you mean formulas.

If you have a group on {table.provider}, then you should be able to add the percentages by using formulas something like:

//{@admitted%}:
sum({@admitted},{table.provider}) % sum({table.visits})

//using {table.visits} to represent the field contributing to the "Total" column. But I'm guessing here.

-LB