Real to Fake Timescale
I am trying to map the Anaplan monthly timescale to a fake timescale that I have created.
I have a location that has a date MM/DD/YY in which I am wanting to map that to my Month list that consists of Month 1 through Month 60. I am trying to do a formula that will map that date as the Month 1 list item and then each month after that number it Month 2 - Month 60. I have gotten it to map the Month 1 to the actual month, but I am stuck trying to get the months after that to map. Could someone help me?