Skip to Content
0
Former Member
Apr 24, 2008 at 05:47 AM

How to get the Total Number of records in a particular Job Group.

35 Views

Hi All,

In my requiremnt I'm supposed to calculate the Average hrs based on (Average Hours is the total of Combined YTD Hours worked for a group of employees divided by the total no of records in that particular job group).

Suppose let us assume Avrghrs = X divided by Y.

where X = Combined YTD Hours (this logic is done)

Y = Total no: of records (total no of records in that particular job group)

Can any body let me know how to get the count of the records for a particular group.