calculation in Report

[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!

 

[Duane Hookom]

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.