AnsweredAssumed Answered

Two months prior numeric

Question asked by STELLA on Jan 10, 2018
Latest reply on Jan 10, 2018 by STELLA

Hello,

 

I am trying to return the month nomenclature along with the value and I can't make it work for January. So far, Month('*')-2 has worked out well, but for January, since its numeric is 1, when I want to return results for November it gives back -1. I guess on February it is going to be giving back 0 for December.

Any ideas?

 

Thank you!

Outcomes