Solved

difference vs last 4 years ago

Hello,

I am trying to get current month vs 4 years before same month variance. Can you please help?

I tried using the offset calculation to offset by 48 months ago, but it is giving me 4 years ago value rather than the difference.

So, Aug 23 is 10.9 and Aug 19 is 9.5. So I need to get the result of 1.4 in a new column.

Thanks in advance!

Userlevel 6

+12

Hello,

You need to do a variance and then you’ll have the offset option on one part of the variance.

Sign up