Day Timescale and Date formatted line item
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.
It should still work even if the date is displayed in a different format
I hope that helps
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.
@kavinkumar Why not LOOKUP in both cases as you are simply referring the value basis on date?0