Turnover Report

[CKingery]

I am having trouble creating a turnover report in a cross-tab format.

I would like to pull from PeopleSoft Query a list of all active and
termed individuals and then divide the active by the termed and
display all the data in a cross-tab that displays the count of each
and the calulation. Sounds easy, but it is for 160,000 records and
needs to be in rows by Division and then columns by organization.

I can only pull from PeopleSoft through Query ODBC one query per
report.

Any suggestions??

 

[IdoMillet]

Create a formula that returns 1 (or 100) for active and zero for termed individuals.

In the CrossTab use that formula with an AVERAGE for the sum operation. This would give you the "% active"

Cheers,
- Ido ixm7@psu.edu

 

[CKingery]

I did as you said and it worked, but in the total columns I am still not getting correct summary data. The totals are correct, but the total turnover percentages are not correct. How would you get around this?

 

[IdoMillet]

What exactly came out right and what didn't?

Cheers,
- Ido ixm7@psu.edu