0 Replies Latest reply: Feb 24, 2016 11:42 AM by PAUL YEO RSS

    How to compute 1/Feb - Today Amount by year ?

    PAUL YEO

      Hi All

       

       

      I have this expression is working fine , it will display YTD sales by year ( Jan and Feb ) :-

       

       

      money(sum(-$(ColumnDim51)/$(Columndim89) * YearToDate(date, year-Year(Today())))/1000,$(vMoneyFormatK))

       

       

      Now it display :-

       

       

      Examople now is 24/2/16 :-

       

       

      1st bar will display 1/1/16 - 24/2/16

      2st bar will display 1/1/15 - 24/2/15

      3st bar will display 1/1/14 - 24/2/14

       

       

      As i need to display Current month Feb 2016 MTD sales.

       

       

      May i know how to modify the above expression , only Feb month to date sales.

       

       

      Examople now is 24/2/16 :-

       

       

      1st bar will display 1/2/16 - 24/2/16

      2st bar will display 1/2/15 - 24/2/15

      3st bar will display 1/2/14 - 24/2/14

       

       

      Hope some one can help me.

       

       

       

       

      Paul