3 Replies Latest reply: May 25, 2016 7:34 AM by PAUL YEO RSS

    Set Expression Month = {"<=$(=max(Month)-1)"} Does not return last month sales

    PAUL YEO

      Hi All

       

       

      Below expression return current month sales correctly :-

       

       

      Sum(Aggr(SUM({

      <

      year = {$(=only(year))},

      Month = {"<=$(=max(Month))"},

      rEVENUE={rEVENUE}

      >

      }Amount*1)/$(Columndim89)/1000, $(ColumnDim101)))

       

       

       

       

      I modify the above exoression to get the last month revenue as below :-

       

       

      Sum(Aggr(SUM({

      <

      year = {$(=only(year))},

      Month = {"<=$(=max(Month)-1)"},

      rEVENUE={rEVENUE}

      >

      }Amount*1)/$(Columndim89)/1000, $(ColumnDim101)))

       

       

      I get null value , can some one advise me where i go wrong ?

       

       

      Paul