Totals of 2 percentage queries not matching.

[Huddle]

I have 2 queries, AreaCombo and Combo, each calculating percentages

% Presented:[Presented]/[Area Totals] and % Presented:[Presented]/[Target Totals]


The percentages come out fine on the % Presented on each query.

Where I'm having trouble is on the each report (Area and Target) when I do a field calculation of =Avg([% Presented]) the Averages don't match.

The data is the same just broke down a different way in each query.



I know it is a rounding issue but didn't know if there was a formula I could use that would better help in the rounding problem.

[June7]

Maybe use Round() function.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Huddle]

Changed the formula to =Sum([Presented])/Sum([Target Totals]) and it works.