Using Lookup with offset or lag function

mohitveer_sandhu
Occasional Contributor

Using Lookup with offset or lag function

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.

13 REPLIES 13
mohitveer_sandhu
Occasional Contributor

@einas.ibrahim 

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

einas.ibrahim
Master Anaplanner/Community Boss

@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.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
kavinkumar
Certified Master Anaplanner

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.

Regards,
Kavin.
mohitveer_sandhu
Occasional Contributor

@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