5 Replies Latest reply: Feb 24, 2016 11:24 AM by Sunny Talwar RSS

    SET Expression for getting Jan 2016 amount ?

    PAUL YEO

      Hi All

       

       

      I have below expression will return CYTD ( Jan and Feb ) amount , is working fine :-

       

       

      money(

      sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} $(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

      May i know how to modify the above expression , so that it will return CY ( Jan ) Amount ?

       

       

      Paul