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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress groups totaling less than $5,000 1

Status
Not open for further replies.

loveyoursite

Technical User
Apr 14, 2005
100
US
CRV10. I have a report grouped by employee showing deductions thus far this year. In Group Footer #1 I have a Summary field (Sum of PAYDEDUCTN.DED_AMT) showing the total deductions to date.

I'm suppressing the detail section, and only want the groups to show that have a Sum of PAYDEDUCTN.DED_AMT of greater than or equal to $5,000.00.

I would appreciate any direction on how best to go about this. Thanks!
 
Try:

Report->Selection Formulas->Group

sum({table.PAYDEDUCTN.DED_AMT},{table.empoyee}) >= 5000

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top