Highlighted
Certified Master Anaplanner

Day Timescale and Date formatted line item

Hi All,

 

I have a model with Week General time settings.  Module 1 uses Day timescale and Module 2 has Date formatted line item.  How can I lookup line item in Module 1 using Date formatted line item in Module 2?

 

The Day timescale in Module 2 appears as 10 Apr 2019 while Date line item in Module 2 appears as 4/10/2019.  I think I need to convert 4/10/2019 to the format of Day timescale.  However, I do not find that I can format a line item as Day timescale.

 

Thanks,

Andre

 

 

2 REPLIES 2
Community Boss

Re: Day Timescale and Date formatted line item

@andre.lie 

It should still work even if the date is displayed in a different format

2019-05-07_13-00-47.png

 

2019-05-07_13-01-11.pngI hope that helps

David

 

Certified Master Anaplanner

Re: Day Timescale and Date formatted line item

HI Andre,

 

I am not clear on the requirement but please see my below findings.

 

1.If you are trying to pull the data from Module 2 to Module 1 then use SUM.

Day Timescale and Date formatted line item.PNGDay Timescale and Date formatted line item 1.PNG

 

2. If you are trying to pull the data from Module 1 to Module 2 then use LOOKUP.

 

Day Timescale and Date formatted line item 2.PNGDay Timescale and Date formatted line item 3.PNG

I think this helps you to solve the concern.

 

Regards,

Kavin.