5 Replies Latest reply: Jun 10, 2016 6:48 AM by Nhu Ngo RSS

    How to compute Stock Amount using RangeSum(Above( and get amount =-1,505,155.9  ?

    PAUL YEO

      Hi All

       

       

      when i compute using Sum(Amount) it return amount =-1,505,155.9

       

       

      But when i using below expression :-

       

       

      ADD RATE FOR GL TABLE

       

       

      =

      RangeSum(

      Above(

      RangeSum(

      Above(

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

      -

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

      YearMonth)))

       

       

      Now it return -361,237,416 , How to make it return 1,505,155.9 ?

       

       

      Paul