Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sory second expression is MakeDate(FYear_Targets,(MONTH_YEAR+$(vCM))-1)