Day Timescale and Date formatted line item

andre.lie
edited November 2022 in Modeling

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

 

 

Answers

  • DavidSmith
    edited November 2022

    @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

     

  • kavinkumar
    edited November 2022

    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.

  • CommunityMember126793
    edited November 2022

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