Highlighted
Community Boss

Return Value from Module with Time Dimension

Hi Guys,

 

This might be simple to some but I am having problem with the result here. See below

 

Module 1 is a module where users input the start of Data of Projection, this is their input module. Module 2 on the other hand is a Line Item named Value and a Time Dimension. So if a user input a Date (Time Period format) April 2020 on Module 1 it will then look to the Module 2 and return the value with the same Date (Time Period) from Module 1 as seen below. I have 2 examples here hope it makes sense.

 

Jsdeloria21_0-1589878521174.png

Any ideas on this let me know and thank you in advance.

 

Regards.

2 REPLIES 2
Highlighted
Community Boss

Re: Return Value from Module with Time Dimension

@Jsdeloria21 

 

Use SUM function. See if this helps

 

Module 1:

Misbah_0-1589880612523.png

Module 2: 

Misbah_1-1589880638791.png

 

Highlighted
Regular Contributor

Re: Return Value from Module with Time Dimension

Hi @Jsdeloria21 

 

it is a case of lookup, you can simply use module2.value[lookup: start date] as start date is period formatted, so it will retrieve value from module 2 as per requested period

Kanishq17_2-1589888028795.png

 

 

 

Kanishq17_1-1589887979506.png