Hi,

I'm creating a report with detailed data and 3 groups.
At the first group footer I'm calculating two numbers:
a percentage figure and a number which give my result.
So far no problem either with "Calculate" in the fields or
report variables.

Now I want to sum my result of the first group to print a total
in group footer 2 and 3. And there is the problem - all further
calculations are based on the detailed data rows but I want to use
the result of the first group footer. Due to the percentage
calculation at the end of group footer 1 there seems no
way to do this. Any suggestions (except calculating the totals
before the report)?

Data Rows:
2 100$
3 500$
10 50$

Group footer 1:
15% of 650$ result is 97,5$

Group footer 2 + 3: sum all results of 1 (97,5 + ....)
Using detail leads to wrong calculations (2% of 100$ + 3% of 500$ +
10% of 50$ is giving 22$ and not 97,5$). groups.

Is there a possibility with report variables to get information
about group changes (I know only the reset option): e.g.

total = IIF(groupchange1=.T.,total+result,total)

Thanks.

Andreas