Using Percentages in Groupings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report has
1. Detail
2. First Group: DIV
3. Second Group: REGION
4. Third Group: STATE

My report includes fields directly from the table but it also includes
complex calculations from a query. Everything works great in the Detail
level, however, I am not getting a percentage on the group levels since these
calculations are weighted. The groupings include "First" in the calculations
when I attempt to recreate the calcs for the group level. How can I get the
weighted percentages for my DIVISION and REGION levels?
 
Hello "SharonInGeorgia"

My report has
1. Detail
2. First Group: DIV
3. Second Group: REGION
4. Third Group: STATE

My report includes fields directly from the table but it also
includes complex calculations from a query. Everything works
great in the Detail level, however, I am not getting a percentage
on the group levels since these calculations are weighted.
The groupings include "First" in the calculations when I attempt
to recreate the calcs for the group level. How can I get the
weighted percentages for my DIVISION and REGION levels?
Click to expand...

What is the logic behind your weighted percentage?
When using aggregate functions in calculated expressions in
group headers/footers, the arguments of these functions must not
be expressions that reference controls.
Therefore, if you made a complex calculation in a textbox in the
detail section and if you then wanted to calculate the sum of these
values in the group footer, you had to repeat the complex expression
in the max function instead of something like max([mytextbox]).
Always use field names from the record source in such expressions.
 
Back
Top