6 Replies Latest reply: May 11, 2016 10:40 PM by Yeo Poh sai RSS

    How to insert my field = sTOCK into my expression ?

    Yeo Poh sai

      Hi All



      I hv below expression working fine , need to click on button to filter GL_CODE=50010



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

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




      I have add the field for sTOCK , which will filter GL_CODE=50010:-



      If([Reporting Code]>=50010 and [Reporting Code]<=50010,'sTOCK') as [sTOCK],



      My i know how to insert the filed sTOCK into above expression ?



      Table 1 16 April should get -111,135 Amount.