Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are the expressions for the Sum of Sales of
Year to Date
Quarter to Date
and Month to date?
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