Using Lookup with offset or lag function

Highlighted
Occasional Contributor

Re: Using Lookup with offset or lag function

@einas.ibrahim 

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

Highlighted
Valued Contributor

Re: Using Lookup with offset or lag function

@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"
Highlighted
Master Anaplanner/Community Boss

Re: Using Lookup with offset or lag function

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.
Highlighted
Occasional Contributor

Re: Using Lookup with offset or lag function

@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