General information
Category:
Reports & Report designer
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only