Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to All.
I have confusion following calculation
I want find YTD, Please help me out this issue.
Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)
Here what can i use instead of DateField and DateNum
Please explain to me
I have Date field like "BILLDATE".
Where can i mention in above expression.
I have two variables like (1).vStartDate
(2).vEndDate
and i have fields like MinOrddate & MaxOrdDate in script.
Please form an expression for YTD by using above values.
Please help me out this issue.
Thanks in Advance
Regards
Chandra.
SUM({<
Year =, Quarter=, Month=, Week=, BILLDATE=,
BILLDATE={">=$(=Date(YearStart(Max(BILLDATE))))<=$(=Date(Max(BILLDATE)))"}
>}Sales)
Hi Manish,
Thanks for your reply.
Can you Please give me MTD & WTD also.
i cant able get that.
please help me out this issue
Thanks in advance.
MTD
SUM({<
Year =, Quarter=, Month=, Week=, BILLDATE=,
BILLDATE={">=$(=Date(MonthStart(Max(BILLDATE))))<=$(=Date(Max(BILLDATE)))"}
>}Sales)
WTD
SUM({<
Year =, Quarter=, Month=, Week=, BILLDATE=,
BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE))))<=$(=Date(Max(BILLDATE)))"}
>}Sales)