calculation in Report

  • Thread starter Thread starter Hong
  • Start date Start date
H

Hong

Hello, I created a report base on a crosstab query.
The report will show the sales focus change.
January focus for the next 12 month,
February focus for the next 12 month, and so on.

But I need to calculate the difference for each month focus change.
for example on January I get the focus for March is 1000.
and on Febuary I get the focus for March is 900. On March I get another
focus on March is 1100, so I need to calculate the change of percentage.
February's date compare with January's data, March's data compare with
January's data.
Is that possible to do that in the report?

Thank you!
 
You should be able to use an expression in the control source of a text box
like:
=([March]-[February])/[February]
If this doesn't work, come back with more significant information about your
report and its record source.
 
Back
Top