Offset Function to get monthly value

[tompatrick.ting]

Hi,

Please help how I can get the monthly value from our DATA Collect to a line item in Year format.

In my example screenshot below, I need to pull the Jan 2020 data to the Jan line item. I tried to use offset to get the Jan value but with no luck.

Thanks in advance for helping,

Tom

[anirudh · Accepted solution]

Hey Tom,

Try:
DATA[SELECT: Time.'Jan 20']

Although as a long term solution, you'll want to create a line item subset from the Jan, Feb etc line items and map them with Anaplan time. Then use the formula
DATA[LOOKUP: LIS to Time.Mapping]

Let me know if you need more help

Regards,
Anirudh

[tompatrick.ting]

Thanks @anirudh for this. The lookup in the LIS item works.

Best regards,

Tom