5 Replies Latest reply: Apr 21, 2016 5:09 PM by Yeo Poh sai RSS

    How to convert expression into load script ?

    Yeo Poh sai

      Hi All

       

       

      My Table 1 Expression working fine :-

       

       

      RangeSum(

      Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),

      -Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))

       

       

      Now i like to convert this into load script :-

       

       

      RangeSum(

      Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),

      -Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth))) as STK

       

       

      I get error msg :-

       

       

      Error in expression:

      ABOVE is not a valid function

       

       

       

       

      left keep (GL_TABLE)

       

       

       

       

      Paul