how to compare values

[Former Member]

Hello,

I have a Cross tab report with values from different months. I would like to have a formula to compare previous months value with the next one. Is this possible?

thanks

Richie

[amitrathi239 · Accepted solution]

try with this.

=Previous([Impact Score];([Clinic Name]))-[Impact Score]

[Former Member]

thanks so much! it worked.

[nscheaffer]

Take a look at creating a variable using the Previous function.

Noel