Page 1 of 1

Report won^t exclude a value

Posted: Tue Nov 16, 2004 6:13 pm
by 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

=> RE: Report won^t exclude a value

Posted: Tue Nov 16, 2004 10:48 pm
by 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