Get Last data in all time

hyudolee
Occasional Contributor

Get Last data in all time

Hi, I use week General as Time setting.

I want to get Last day in all time.

 

Module A

Time2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/7
Num1111111
Offset(Num,1,0)1111110
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

ProductLast day
A2021/1/7
B2021/1/7
C2021/1/7

 

Do you have any idea?

1 ACCEPTED SOLUTION

Accepted Solutions
SathyaM
Certified Master Anaplanner

Re: Get Last data in all time

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.

View solution in original post

2 REPLIES 2
SathyaM
Certified Master Anaplanner

Re: Get Last data in all time

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.

View solution in original post

hyudolee
Occasional Contributor

Re: Get Last data in all time

Hi, @SathyaM .

Thanks for replay!

I will use timesum function.