Hello Power

Yes you can. The report writer allows you to create variables.

Instead of creating normal totals for your columns create and use variables that will contains these totals.

Then you can use these variables exactly how you describe.

Click on the report menu and choose variables to start the process.

Make sure you have all the neccesary report toolbars open (layout and report tools)

You should be able to figure the rest out from there.


>If in a report, I created a group, for example, group by month of a date field.
>Then I sum a price field, can I put the different sum of different month into a variable so I can use them in a formula at the bottom of the report?
>For example,
>Jan
>Mr. A $10000
>Mr. B $20000
> Sum1= 30000
>Feb
>Mr. A $2000
>Mr. B $3000
> Sum2= 5000
>----------------------------
> X = Sum1*0.4 + Sum2*0.6 <----- Do some operation by using the sum.
>How can I obtain sum1 and sum2?