Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Not count suppressed employees, how?

Status
Not open for further replies.

Snookless

Technical User
Mar 17, 2003
34
BR
Hello all and thanks for the woderful responces on my other threads, I have a new one here I can not seem to figure out.

I created a group for {employee Name}, then created a formula feild called {@ded} to total up a duduction within a specific date range.
Put the employee name on Group Footer
Put {@ded} on detail line suppressed and created a summary , added the summary to the group footer as well.


Now I have a list of employees with this deduction code and an amount, (I still had to suppress all the other employees that did not have the deduction because the still showed on the report with zero amounts.)

Now the problem I am having is to count only the employees with the deduction that show on the report and enter that total on the report footer.

How can I do this accuratly?
Thanks in advance.
Snookless
 
Use the same criteria you're using to suppress to generate the count.

e.g.
If <Your Criteria Here>
Then 0
Else 1

Then sum this field.

Naith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top