SOLVED - - - Filter not working on large data set

[andy_mason_84]

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