Doing a count on a formula field

[trishtrash]

I have created a report group first by year and then by Ticket number. Under each ticket there is a list of progression times which have been totaled to give me total time per ticket (number). Another formula sets a status 1, 2 or 3 for the length of time (eg status 1 represts 0 mins or less) this field is a string.
I need to do a count on the Status field per year. I am unable to enter a group on the Status code and when I try and create a formula using the status field I get the message "the field can not be used as a group condition"
Can you help please.

 

[Madawc]

I think you need to start from scratch and re-create you totalling for the entire report. Crystal will not summarise fields that are themselves summaries.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

You need to show the content of the formula for status.

-LB

 

[trishtrash]

The Formula for Status is as follows:-

if {@Total time per call} <=20 then "1" else
If {@Total time per call} <=100 and {@Total time per call} > 20 then "2" else
If {@Total time per call} >100 then "3

 

[lbass]

And the contents of any nested formulas.

-LB

 

[trishtrash]

Sorry the nested formula is as follows:

Sum ({@Progression Time},{calls.Call Number} )

 

[lbass]

And the contents of any nested formulas.

-LB

 

[trishtrash]

Again Sorry formula:-
(hour({Call_Progression.Time Spent})*60)+ minute({Call_Progression.Time Spent})

 

[lbass]

Since there are only three, I would just use three separate running totals that do a distinctcount of {table.ticketno}, evaluate using a formula->x+2->

Sum({@Progression Time},{calls.Call Number}) <= 20

Reset on change of group (your year group). In the other two running totals, change the evaluation formula to reflect the correct ranges. Place the running total in the year goup footer.

-LB

 

[trishtrash]

Thank you that has worked. Appreciate your help