3 Replies Latest reply: Jun 2, 2016 10:32 PM by PAUL YEO RSS

    SET expression current month ok previous not ok

    PAUL YEO

      Hi All

       

       

      I have below expression working fine for retuen current selected month amount :-

       

       

      (

      sum({$

      <

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

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

      >

      }   Amount/1000)

      )

       

       

      I try to modify the above expression to below , in order to display previous month sales :-

       

       

      (

      sum({$

      <

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

      Month = {"<=$(=max({<year={$(=max(year))}>} Month))>$(=max({<year={$(=max(year))}>} Month)-2)"}

      >

      }   Amount/1000)

      )

       

       

      But it return null value. Can some one advise me where go wrong ?

       

       

      Paul