Skip to Content
0
Former Member
Dec 07, 2009 at 07:05 PM

Forumla output count

27 Views

Hello,

I have a formula outputing 1 if the employee gets paid for the month and 0 if they don't get paid.

I would like to count the sum of employees who are getting paid. Here is an example of what the output should look like.

Apr Emp     Gross         Apr Emp Count
  1      100          2
  1      150
  0       0

I tried doing : Count ({@Apr Emp}) but it tells me that the field cannot be summarized.

Any idea on how to do this?

Thank you

Edited by: nabilino on Dec 7, 2009 8:05 PM

Edited by: nabilino on Dec 7, 2009 8:06 PM

Edited by: nabilino on Dec 7, 2009 8:07 PM

Edited by: nabilino on Dec 7, 2009 8:07 PM