Offset Function to get monthly value

Highlighted
Occasional Contributor

Offset Function to get monthly value

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.

tompatrickting_0-1600833133194.png

tompatrickting_1-1600833258625.png

 

Thanks in advance for helping,

Tom

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Offset Function to get monthly value

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

Re: Offset Function to get monthly value

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

 

Best regards,

Tom