Compare two values on different dates

What would be the best way to compare two values a year apart?

Say I have
Date                            Used
October 4, 2016          3,334
November 5, 2016      4,999
December 12, 2016    4,698
etc...
October 7, 2017          3,999

What would be the best way to compare the two October dates?  And then next month compare the two November dates, and so on.  Basically each month we would compare current month minus same month last year.

Thanks.
LVL 3
ThomasBallardITAsked:
Who is Participating?
 
mlmccCommented:
Do you actually want to subtract last year from this year?

Create a formula
If Year({DateFIeld}) = Year(CurrentDateTime) then
     {AmountField}
Else
    - {AmountField}

Open in new window


Create another formula
  MonthNumber({DateField}) 

Open in new window


Group on the Month Number formula
Insert the field on the report
Create a summary of the field in the Month Number group footer

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.