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

    How to compute GL CODE from 50055 till 50057

    PAUL YEO

      Hi All

       

      I try :-

       

      >=50055 and <=50057

       

      into below expression :-

       

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

       

      it return zero.

       

      Paul