Solved

# Crystal Reports 10: percentage

Posted on 2008-10-21

My Crystal Reports 10 report gives the totals of a field based on what is in the field

Selection:

Count of field where x

Count of field where y

Count of field where z

It is easy then to get a total count of those records included in the field.

Count or RunningCount.

In addition there are data elements that may be described as a or b or c. These data fields are not included in the RunningCount.

However, I would like to get a Count of all the data fields, not just the x, y and z fields.

I want to show : ( (RunningCount [x,y,z] fields) / (All fields [where all x, y, z and a, b, c, for example]) as a percentage.

Is there a way to count all fields, not just those selected? to use as the denominator for the % calculation

NOTE: No points will be rewarded for answers that simply refer me to a book. I am looking for a solution, not a reference.