Filter on Calculated Data Item Not Working

[dolphins62]

I have a report that joins several queries. I defined a data item as a total and I am printing the total amount. No problem with this part.
I would like to print only customers with a total > 25. I tried the following
- creating a filter on the total data item after aggregation. It returns an empty report, even though some customers meet the criteria
- creating a summary filter, checking the calculated field. his returned invalid error.
- Creating a query that referenced the query performing the total calculation and creating a filter on the total value (total > 25). All customers are displayed, regardless of total.

How can I filter the result of my calculated total to display only records with a total > 25?

 

[blom0344]

Did you check the generated SQL involved? If you use in-report joins then adding a filter to 1 query may not work like you expect..

Ties Blom