Skip to main content

Hello All,

 

I’m currently trying to build an effective date for Merit increases and my input is as follows dimensioned by country and year.

 

Right now, I’m trying to populate the table below with the month of the year e.g. FY23 should should December. I tried writing a formula TIMEDIM(ASM_Input_Merit Date, Month) and convert the data by Month.Month of the Year but it doesn’t work.

 

Any suggestions on how I should write this formula?

Hi Kelvin
Please ensure that data type of ASM_Input_Merit Month is Dimension ‘Month of the year’ and then try formula: 
TIMEDIM(ASM_Input_Merit Date, Month).'Month of Year'
From TIMEDIM system will generate month and then by adding .’Month of Year’ it will map it to Month of Year items :) 
I hope it helps!


Reply