Transfer Value from Time Period to List

Atz1234

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.

my mapping:

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

devrathahuja

Hi @ArthurA ,
Swap the mapping-

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.