20 Replies Latest reply: Aug 3, 2016 5:21 AM by Ruben Marin RSS

    RangeSum(Above(RangeSum(Above( Why need repeat twice ?

    PAUL YEO

      Hi All

       

      Below expression from Sunny :-

       

      RangeSum(Above(RangeSum

      (Above(

      Sum

      (

      {

      <

      year, month, aR={aR}

      >

      }

      [Amount]*1)/Rate, 0, RowNo()))),

      -

      Sum(

      {

      <

      aR={aR}>

      }

      TOTAL Aggr(Sum(

      {

      <

      year, month, aR={aR}

      >

      }

      [Amount]*1)/Rate, YearMonth

      )))

       

      above expression work fine.

       

      Can some one share with me why it repeat twice on RangeSum(Above :-


      RangeSum(Above(RangeSum(Above(



      Paul