Percentage of a summarized grouped field by another sum grouped field 1

[bnsSteve]

Hello,

I'm trying to get a percentage of a summarized field that is grouped by month by another summarized field that is group by month. (Would like to get the %Worked column below)

Ex:
Gr.by.month Dist_Cnt_Apps Dist_Cnt_Apps_wrkd %Worked
Jan 150 25 16.67%
Feb 300 100 33.33%
Mar 50 10 20.00%
Total 500 135 27.00%

All the way's I've tried, just returns the Total Percentage worked. But not the percentage of each month for each month (i.e, 27%)

Not the most complicated problem.
Thank you for the help!
Steve.

 

[lbass]

Create a formula like this:

distinctcount({table.appswrkd},{table.date},"monthly")%
distinctcount({table.Apps},{table.date},"monthly")

Place this in the group section and click on the "%" icon.

-LB

 

[bnsSteve]

Perfect!

Thanks for the quick reply LB.
Steve.

 

[bnsSteve]

Is it possible to do this with a running total field?

Meaning, I have another column that is summarized by a running total. I would like to show this running total column as a % of another summarized field (not running total).

I've tried using the running total in the formula, but get an error saying 'this field cannot be summarized'

Thanks again.
Steve.

 

[lbass]

The running total is already a summary, so the formula would look something like this:

{#runningtotal}%distinctcount({table.Apps},{table.date},"monthly")

-LB

 

[bnsSteve]

Works great!

Thanks again LB,
Steve.

Running Crystal 14.0.2.364