Skip to Content
avatar image
Former Member

how to compare values

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 20, 2015 at 07:53 PM

    try with this.

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 07:41 PM

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

    Noel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2015 at 08:28 PM

    thanks so much! it worked.

    Add comment
    10|10000 characters needed characters exceeded