Highlighted
Contributor

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?

 

date.JPG

time mapping.JPG

 

 

 

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Real to Fake Timescale

Hi @dgregs 

 

Do see if the following works:

 

1. Create Fake Mth as shown below. I only created 24 members but you can expand to 60 members.

Screen Shot 2019-12-23 at 18.36.17.png

2. Cost Center Date Module is created to capture Date of 1st month.

Screen Shot 2019-12-23 at 18.36.22.png

3. Another module, i.e. 'Date to Fake Mth' is created. Results are shown in 'Fake Month (List)'.

Screen Shot 2019-12-23 at 18.36.49.png

4. Blueprint of 'Date to Fake Mth' module.

Screen Shot 2019-12-23 at 18.40.14.png

 

Thanks,

LipChean

Highlighted
Contributor

Re: Real to Fake Timescale

Thanks so much @LipChean_Soh ! This worked flawlessly and saved me so much time! Appreciate the quick response! 🙂

Master Anaplanner/Community Boss

Re: Real to Fake Timescale

No worries.

Happy holidays.

 

Regards,

LipChean