Offset Function to get monthly value

tompatrick.ting
tompatrick.ting
in Modeling

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

Tagged:

Best Answer

  • anirudh
    anirudh
    Answer ✓
    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

Answers

Categories