Report won^t exclude a value

[Sherri_(Guest)]

In my report, I have numerous calculations that figure out different yield percentages for each record. For Yield % A, I have calculation A; for Yield % B, I have calculation B; etc.____Most of the yields are around 60-70%, but some are above 100%.____When I create a filter to only print records where Yield A is greater than 100, it returns 0 records ... even though I know for sure that there are some records for Yield A where the yield is greater than 100%.____Why won^t it filter these out?____Thanks

[kfleming]

If the yield is a numeric field that is formatted as a percent, isn^t 100% really the numeric value 1? Is that maybe why it is not working?____Kathleen__R&R Support