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
| 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?
Tagged:
0
Best Answer
-
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.
0
