2 Replies Latest reply: Jun 3, 2014 2:21 AM by Omar Nouri RSS

    Set Expression how to modify so it will compute previous month amount ?

      Hi All

       

       

      Below expression working fine. as it display max month amount.

       

       

      money(

      FABS(

      sum({$<year = {$(=max(year))}, Month = {"<=$(=max({<year={$(=max(year))}>} Month))>$(=max({<year={$(=max(year))}>} Month)-1)"}>}   Amount/1000/$(ColumnDim98))

      )

      , $(vMoneyFormatK_GL))

       

       

       

       

      I like to modify this expression to display previous month amount instead of current month amount. may i know how where should i make changes ? See my enclsoed QV Doc in my next post.

       

       

      Paul