Skip to main content

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! 

 

 

 

 

 

Hello,

 

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


Reply