getting average in crystal result..

hi please help me here i want to get the average of the of the entry
ex.

in ym database
i have

Code:

---

ID      Name        Status          NoWorkingdays      month  Time
1        a              Present            20                    1          AM
2        ab            Present            20                    1          AM
3        abc          Present            20                    1          AM
4        abcd        Absent              20                    1            AM 
5        abcde        Leave              20                    1            AM
1        a              Present            20                    1          PM
5        abcde        Leave              20                    1          PM

---

i want to get the result per status count
this is done in querry of access

Code:

---

tabale Records
Status          StatusCount        Frequency(Formula    is:StatusCount/noworkingdays)          Percentage (what statusCount / totalrecord
Present            3                          0.15 (3/20)
Absent            1                          0.05 (1/20)
Leave              1                          0.05  (1/20)

---

Please help..

Here's a long way to do it.

On you report you can create 3 data fields in the detail record. Call them Present, Absent, leave. As you read each record , check the status. Add 1 to the buckets you created (i.e., if status = absent, then absent = 1,). Put the variables on a detail line (invisible). Total them up at the report footer and format your footer to look like what you showed in your post. The total count, average, etc are just formulas you can put in the footer as well.

I hope that makes sense to you.