Solved

difference vs last 4 years ago

  • 12 October 2023
  • 1 reply
  • 64 views

Userlevel 3
Badge +6
  • Newly Minted Pigmenteer
  • 21 replies

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

View original

1 reply

Userlevel 6
Badge +11

Hello,

 

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

Reply