Using Lookup with offset or lag function

[mohitveer_sandhu]

Hi,
I have a module (MOD01) with time and 'A' as dimensions and a line item x.

In another module (MOD02) I want to have a value of say in JUN 20 I need value of x from JAN 19 based on the Dimension 'A'(by lookup).

So which function should I use or how can I use lookup with time period function.

[mohitveer_sandhu]

@einas.ibrahim 

Isn't there any solution without creating any extra line item.

[einas.ibrahim]

@mohitveer_sandhu 

Not that I can think of.

a lot of Anaplan formulas don’t work in a nested way. Also, it’s best practice to breakdown formulas anyway.

[kavinkumar]

Ideally, it should work and it does work for me. Can you post the error message after writing the formula?

Maybe another way to achieve this is by creating 2 line items. One to bring the value as is through lookup function. Then in the second line item apply Offset/Lag on the first line item.

I hope this helps.

[mohitveer_sandhu]

@kavinkumar Here is the error message

The formula for 'MOD02'.test is invalid:

'MOD02'.test = OFFSET('MOD01'.x[LOOKUP: A], offset_value, 0)
Offset value has -ve number's based on the difference between JUN20 and JAN 19