Time dimension formula
Source Module has Year, Target module has Months.
Source - Time dimension (YEAR), Cost center dimension, Line Item
Target - Time dimension (Months), Cost Center dimension, Line item
Source has rate by year, for example for FY23,
Want to bring FY23 rates to all the months in target module. What formula would i use in terms of time.
You should use YEARVALUE() formula:
or alternatively, you can create SYS module with line item dimension of Months, format as Year (let's name it "Year"). Then you can use formula like Source[LOOKUP: SYS.Year].2