This is solved.
I had made a mistake in another Expression which did not take into account suppliers with the same name but different codes.
Thanks to anyone who had spared a thought for this!
___________________________________________________________________________________________
Hi All,
Right, we have a report that works out Potential Savings which is Price Paid - Minimum Possible Price * Quantity Bought.
I then have a filter that says MAXIMUM([Potential Savings] for [Product Code]) > 0
So that the report only shows those records that have potential savings ...
This works when the data set is small ... but once I load lots of records and run the report it seems to ignore the filter and bring back recorder where the maximum is 0?
Is this just a coincidence?
Any ideas why this would do this?
Cheers,
AM