getting average in crystal result..

[edgarbenilde]

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

in ym database
i have

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

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..

[Pasvorto]

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.