Scenaria Help

abhaysingh — Thu, 15 Jan 2015 11:32:41 GMT

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

Re: Scenaria Help

abhaysingh — Thu, 15 Jan 2015 11:34:56 GMT

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