Isn't there any solution without creating any extra line item.
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.
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.
@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