6 Replies Latest reply: May 11, 2016 10:40 PM by PAUL YEO RSS

    How to insert my field = sTOCK into my expression ?

    PAUL YEO

      Hi All

       

       

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

      =

      (RangeSum(

      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.

       

       

      Paul