8 Replies Latest reply: Feb 17, 2016 11:06 PM by PAUL YEO RSS

    How to add set expression with add (RangeSum(Above ?

    PAUL YEO

      Hi Sunny

       

       

       

       

      I have one more expression need to add above(range ,

       

       

      money(

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

      , $(vMoneyFormatK))

       

       

       

       

      I have try below exrepssion but it does not work :-

       

       

      Money

      (RangeSum(Above

      (TOTAL Sum(DISTINCT

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

      , 0, RowNo(TOTAL)

      ))

      , $(vMoneyFormatK))

       

       

       

       

      Paul