1 Reply Latest reply: Jan 3, 2013 6:01 AM by Nirav Bhimani RSS

    YTD Expression Issue

      Hi,

      I want to create an expression which will calculate the sum of my dimension from april month of a year to current date.

       

      Thanks,

      Utsav

        • Re: YTD Expression Issue
          Nirav Bhimani

          Hi,

           

          you are using financial year or normal year?

          this work with Fin Year as you want.

           

          In Script // QuarterStart(CalendarDate) as QuaterStartDate,

          In Variable //vMaxDate= Max(CalendarDate) OR vMaxDate= (Today())

                                             

          (sum(
          {<
          CalendarDate = {">=$(= Date (
          min({<CalendarWeekOfYear=, FinancialQuarter=, MonthName=>} QuaterStartDate )))<=$(vMaxDate))" }
          , CalendarWeekOfYear=, FinancialQuarter=, MonthName=
          >}
          Sales))


          Hope this will help you.

           

          Regards,

          Nirav Bhimani.