Scenaria Help

[abhaysingh]

Hi all,

i have financial year calender Apr- Mar, which give me

S.NO  Month

1              Apr

2              May

3              jun

;;

;

;

;12          Mar

i have targets having Month value

S.no          Month

1              Apr

2              May

3              jun

;

;

;

12              Mar

and so on

my Master date is like

S.no          Month

Jan              01/01/14

feb                    02/02/14

;

;;

;

;

dec                    01/01/14

Jan                    01/01/15

Feb                02/02/15

Mar              03/03/15

i have joined my target table to fact table by creating Target date with the help of below exp

=MakeDate(FYear_Targets,Mod(MONTH_YEAR+$(vCM), 12)-1)

set (vCM)= 4  (Fixed)

with
this expression from Apr to Oct targets are coming right. from Nov onwards not giving targets

MakeDate(FYear_Targets, (MONTH_YEAR+$(vCM), 12)-1)

with above exp APR to DEC targets coming right but now jan(01/01/2015) is coming and tarrgets are not coming.

kindly help i am struck

[abhaysingh]

sory second expression is MakeDate(FYear_Targets,(MONTH_YEAR+$(vCM))-1)