Day Timescale and Date formatted line item

andre.lie

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

 

 

DavidSmith

@andre.lie 

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

 

I hope that helps

David

 

kavinkumar

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.

 

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

 

I think this helps you to solve the concern.

 

Regards,

Kavin.

CommunityMember126793

@kavinkumar Why not LOOKUP in both cases as you are simply referring the value basis on date?