1 Reply Latest reply: Jun 15, 2016 12:33 AM by Yeo Poh sai RSS

    sum(-sales*YearToDate(date, year-Year(Today()))) How to modify so that compare from Jan till May not till june ?

    Yeo Poh sai

      Hi All



      I have this expression working fine :-



      sum(-sales*YearToDate(date, year-Year(Today())))



      Above expression will comppute Jan till today sales for every year.



      As Now is 15 June , for 2016 june sales data it will only available on 1 July 2016 when account close.



      My question is it is possible to modify the expression to compute the YTD sales till last month , 30 May 2016 and not 1 jan 2016 till 15/6/2016 ?



      So that the compare will be same for CY and LY base on 5 month , and now is compare Last year from 1/1/2015 till 15/6/2015 and current year from 1/1/2016 till 30/5/2016.