crystalfun
Programmer
I have a report that shows line item detail (Co, Dept, Account, Balance) in the detail section. This data is sorted by Project # (project header section). The Project Footer section displays the Total by Project based on the amounts in the detail section.
I want to filter out projects that have total costs less than $100,000. I have been able to filter out the detail based on this criteria but I need to filter out the detail if the sum of the project is > $100K.
Here is what I have tried:
Filter section =Sum([Balance]) > 100000
and
Filter Section Sum([Balance]) > 100000
I received error messages on both
The first being a missing operator and the second "Cannot have aggreate function in Where clause.
Can I filter the detail based on the total of the Sum and if so...How? Thanks.
I want to filter out projects that have total costs less than $100,000. I have been able to filter out the detail based on this criteria but I need to filter out the detail if the sum of the project is > $100K.
Here is what I have tried:
Filter section =Sum([Balance]) > 100000
and
Filter Section Sum([Balance]) > 100000
I received error messages on both
The first being a missing operator and the second "Cannot have aggreate function in Where clause.
Can I filter the detail based on the total of the Sum and if so...How? Thanks.