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?
Power Wong
Every problem will have a solution, the only problem is that can you find it out.