Show Percentage in Cross-Tab in CR 8.5?

[SFBus]

Hi there,

I have a question about showing a percentage in a cross tab in Crystal 8.5. Here is the scenario:

Report is grouped by Location, then Date and then by Operator, and displays the some info on various fields from the SQL database. All is good.

There is a Cross Tab at the bottom of the report that summaries the data for each operator and looks like this.

Status 1 Status 2 Status 3 Status 4 Total
Op 1 20 0 10 2 32
Op 2 10 5 1 2 18
Op 3 8 1 0 1 10
Op 4 12 2 6 0 20

Status = The Various Status of information. A record from the detail section will only appear in one status.

All was good until now, where they would like to now see the percentage of the following as well.

Op 1 Percentage of (Status 1 / Total)
Op 1 Percentage of (Status 1 / (Status 1 + Status 2)
Op 1 Percentage of (Status 3 / (Status 3 + Status 4)
Op 1 Percentage of ((Status 1 + Status 3) / Total)

Repeat for each Operator.

Is this at all possible? As I can't see how it is in Crystal 8.5.

Thank you for your time and suggestions.

 

[CaptainD]

The formula is something like:

ToText(Sum(Status 1)%Count(Status 1))

lbass has some good post with different methods of getting the percentage.

http://www.tek-tips.com/viewthread.cfm?qid=1487372

http://www.tek-tips.com/viewthread.cfm?qid=1516400