Sum of Sales for Year to Date, Quarter to Date, Month to Date

[Anonymous]

What are the expressions for the Sum of Sales of

Year to Date

Quarter to Date

and Month to date?

[v_iyyappan]

Hi ,

     Use this expressoin

     Year to Date = Sum({<Datefield={'>=$(=(Num(YearStart(Max(Datefield)))))<=$(=(Num(Datefield)))'}>}Sales)

     Quarter to Date = Sum({<Datefield={'>=$(=(Num(QuartStart(Max(Datefield)))))<=$(=(Num(Datefield)))'}>}Sales)

     Month to date = Sum({<Datefield={'>=$(=(Num(MonthStart(Max(Datefield)))))<=$(=(Num(Datefield)))'}>}Sales)

Regards,

Iyyappan