Hi Anaplaners,
I am new to Anaplan. Please help!
Module A:
Lisy Y: List of years
Line Items:
LIA1
Format: Number
Value(Has a value stored for every year)
Module B:
Line Items:
LIB1
Format: List Y
Value 2018
LIB2
Format: Number
Value 2
LIB3
Format: Number
Formula: 'Module A'.'LIA1' [LOOKUP: (LIB1+'LIB2')]
I want to get the Value for a future year using this formula and it is not working becase LOOKUP requires a list. I am not sure how to accomodate the future yr in the LOOKUP formula.
Can you please tell me how to resolve this?