Formula for Counting Number of Summarized Fields

[wanzek1]

I need help with a formula to count the number of days worked over 12 hours in a week.

This is what I am looking to create:

S M T W T F S
John Doe
Detail Row 2 3 4 6 9 4 2
Detail Row 9 5 9 4 5 2 9
Total 11 8 13 10 14 6 11

[highlight #FCE94F]# of Days worked over 12 = 2[/highlight]


I have everything working expect the highlighted portion. Is there a way to do a formula to get a day count of the total days worked over 12 hours?

 

[Madawc]

Is that a crosstab or what?

In a report, you could group by days, do a summary total for the day using a variable, and then another in the group footer to add 1 when the total is more than 12. The count that.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP