Module data transfer from time scale to different time range

tejaswini
Contributor

Module data transfer from time scale to different time range

Hello Everyone,

 

I have two modules as mentioned below.I need to get data from module1 Jan20 to module2 Jan21 and same follows for other months.

 

Module1 

Time Scale -FY20(jan to Dem)

Line item - Data

Module2

Time Range -FY21(jan to dec)

line item-data1

 

Can someone help me with this.

 

Thanks

Tejaswini

 

3 REPLIES 3
Misbah
Moderator

Re: Module data transfer from time scale to different time range

@tejaswini 

 

You will have to include FY20 as well in your Target module.

 

Get FY20 data from the source module in Line 1

In Line 2 - Use OFFSET or LAG function to pull the values forward

For example OFFSET(Line 1, -12,0)

 

Misbah

tejaswini
Contributor

Re: Module data transfer from time scale to different time range

@Misbah 

 

Yes this will work.

But is there any other option without including FY20 in our Target module.

Thanks

Tejaswini

 

 

MarkWarren
Expert

Re: Module data transfer from time scale to different time range

You could also create a Month formatted line item with the formula: ITEM(Time) - 12
Either in a system module (if it will be used elsewhere) or in Module 2
Then use that to LOOKUP the value from Module 1