I am totally perplexed with this one .. I am designing a report based on a table that will show each grouping of data totals to 100%. The report is working fine, but one error keeps occuring that I can not correct. This report is based on one table with 4 fields(3 text valued 1 a pct value) My desire is to group on text value sum .pct value to 100% . with a criteria in summed pct field <>1 (The concept is too not show anything if they are 100% as opposed to showing hundreds of fields=100%) . One grouping keeps showing up in my returned value despite being 100% I have increased the decimal places to 15 I have summed values with calculator,even total in Excel, and everytime it shows 100%. Anyone have any better ways to deal with percentage values or any ideas on why this value keeps missing?
