Get Last data in all time

hyudolee

Hi, I use week General as Time setting.

I want to get Last day in all time.

 

Module A

Time	2021/1/1	2021/1/2	2021/1/3	2021/1/4	2021/1/5	2021/1/6	2021/1/7
Num	1	1	1	1	1	1	1
Offset(Num,1,0)	1	1	1	1	1	1	0
Last day							2021/1/7

 

I can get last day in Module A.

But I couldn't get in Module B( has no time, has Product List)

 

Module B

Product	Last day
A	2021/1/7
B	2021/1/7
C	2021/1/7

 

Do you have any idea?

SathyaM

Hi @hyudolee,

 

You can use TIMESUM() function in Module B.

 

For Example: TIMESUM(Module A.Last Day, -1000,1000,LASTNONBLANK)

 

Refer more details here in Anaplan Tech doc --> TIMESUM - Anaplan Technical Documentation

 

Thanks

Sathya.