Getting % in group

[malka]

I have a report that give summary and count in all the group levels and a grand total for each variable.
I will need % of few variables in one of the groups.
Here a short sample.
I have a table of after hours calls.
Groups - Account number, monthly.
At the monthly group - I have total calls for each call taker(2 variables-2 call takers) and the total calls for this company for the month.
I need to calculate the % for each call taker of the total monthly calls, as well as the % at the end of report according to the date parameters that I have provided.

My variables are:
if trim({HickoryMyrnaCalls.CallTaker}) = "H" then
1

And the total for this is a summary of this variable in the month group.

How do I perform the calculation for the %

I hope my question is understood.

Thanks in advance for any reply.

MS.

 

[Madawc]

For Crystal 8.5, you get percentages by writing Formula fields with a command like
ValA % ValB

Thus if ValA is 10 and ValB is 40 you get 25%.

Placing these at group level should get you a group percentage. Or is there some other additional problem that is stopping you doing this?

Madawc Williams
East Anglia, Great Britain

 

[lbass]

Let's call your above formula {@Hcalls}. Then the percent of H's calls within the month would be calculated as follows:

sum({@Hcalls},{table.date},"monthly&quot% count({@Hcalls},{table.date},"monthly&quot

At the report level, the total % of H's calls would be:

sum({@Hcalls}) % count({@Hcalls})

If you wanted the % of all monthly calls compared to all calls during the parameter period, then use a running total for each month, e.g., {#Jan} would be created like this: Select {@Hcalls}, count, evaluate based on a formula:
month({table.date}) = 1 //for January or if there could be more than one year represented, use a date range

Reset never. Then create a formula for each month:

{#Jan}%count({@Hcalls})

You could use any recurring field in the denominator instead of {@Hcalls}, but {@Hcalls} works, too, because it evaluates for each record.

-LB

 

[malka]

Thanks for the quick reply from Madawc Williams and -LB. With your directions I was able to create the % in the monthly group and in the total.

MS