Solved

difference vs last 4 years ago

Userlevel 3

+6

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!

icon

Best answer by Nathan 13 October 2023, 11:00

Userlevel 6

+11

Hello,

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

Sign up