1 Reply Latest reply: Feb 10, 2012 7:10 AM by Iyyappan v RSS

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

    chris goudy

      What are the expressions for the Sum of Sales of

      Year to Date

      Quarter to Date

      and Month to date?

        • Sum of Sales for Year to Date, Quarter to Date, Month to Date
          Iyyappan v

          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