Transfer Value from Time Period to List

ArthurA
ArthurA
edited February 25 in Modeling

Hi everyone. i have time period (weekly). since weekly is the same as gregorian calendar. so i created a list which week 1 to 52.

now i already have data from a module which has a time period.

image.png

my mapping:

image.png

sample is week 8 from Cash Balance Beginning - Copy, it did not reflect in Sys Time Mapping.

image.png
image.png

Best Answer

  • devrathahuja
    devrathahuja
    Answer ✓

    Hi @ArthurA ,
    Swap the mapping-

    image.png


    So instead of having the native time as dimension, have the custom list as a dimension. You can also then use finditem(time,line item) to arrive at the mapping where the line item wold have formula as name(item(custom list)) & "FY25"

    The FY25 can be a separate line item in a SYS Lookup module where you keep it linked to current year/planning year selection, so the mapping updates automatically every year you change the year.

Answers

  • AjayM
    AjayM

    Shouldn't it be [SUM: 'sys time mapping - copy'.time week] ?

  • ArthurA
    ArthurA

    apologies @AjayM i already updated my post..

  • devrathahuja
    devrathahuja

    Hi @ArthurA ,
    You cannot sum over native time to custom list.

    You can create a reverse mapping of the SYS module & use lookup to get the values as it is a 1:1 match for you.

  • ArthurA
    ArthurA

    hi @devrathahuja thank you so much for your reply. may i know what you mean about creating a reverse mapping of the sys module. or can you give an example on how to do it. thank you.

Categories