Crosstab report - can I do math on summaries of the same grouping?

[adriae]

Hi,

I'm running Crystal Reports 2011 and am working on a big H.R. report. In this report, I currently have information grouped on:
1. Department
2. Employee Status (Full time or terminated)

Within each status grouping, I have a summary of the number of employee names that fall within that department/status mix. Ultimately, I need to create a formula that will show a termination rate, or number of terminated employees divided by the number of full time employees. I have not been successful in figuring out how to do this, since the summary counts are both summaries of the same group - employee status.

I also tried to create a calculated member in a crosstab report inserted at the "Department" group level, but cannot figure out how to do that either. Any suggestions would be greatly appreciated!

 

[lbass]

Please explain exactly how the crosstab is set up within the crosstab expert: row field, column field, fields you are summarizing and type of summaries.

-LB

 

[Madawc]

Running totals can use a formula, such as Employee Status. You can also get the same effect using a formula and summary total, e.g.

if {status} = "T"
then 1
else 0

Summing this would give you the number of terminated employees.

The use of Crystal's automated totals is outlined at FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[adriae]

Thank you!
I was trying to do crosstab formulas on counts of string values. After reading your post, I re-did the way I was capturing totals and have it working properly now.

Thanks for the help.