YtD

[#1]

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.

[MK_QSL]

SUM({<

     Year =, Quarter=, Month=, Week=, BILLDATE=,

     BILLDATE={">=$(=Date(YearStart(Max(BILLDATE))))<=$(=Date(Max(BILLDATE)))"}

>}Sales)

[#3]

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.

[MK_QSL]

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)