5 Replies Latest reply: Feb 26, 2016 8:55 AM by PAUL YEO RSS

    How to Add Rangsum function to my SET expression ?

    PAUL YEO

      Hi All

       

       

      I have below expression , i like to add the expression with RangeSum(Above :-

       

       

      money(

      Sum(

      {<Year={'>$(=year(today())-2)'}>}

      $(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

       

       

      I have try the below expression , but it does not work :-

       

       

       

       

      money(RangeSum(Above(TOTAL

      Sum(

      {<Year={'>$(=year(today())-2)'}>}

      $(ColumnDim51)/$(Columndim89)/1000, 0, RowNo(TOTAL)))

      , $(vMoneyFormatK))

       

       

      May i know why ?

       

      In my next posting i will post my QV Doc

       

       

      Paul