2 Replies Latest reply: Apr 20, 2016 10:30 PM by Sunny Talwar RSS

    How to Combine GL_CODE 50057 & 50053 ?

    PAUL YEO

      Hi All

       

      I have below work fine :-

       

      GL_CODE = {50057}

       

      Because i need to add one more number , so i try :-

       

      GL_CODE = {50057}&{50053}


      Money(RangeSum(
      Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50057}&{50053}>}[Amount]*1), 0, RowNo()))),
      -Sum({<GL_CODE = {50057}&{50053}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50057}&{50053}>}[Amount]*1), YearMonth)))
      , $(vMoneyFormatK_GL))

       

      it does not work.

       

      Paul