3 Replies Latest reply: Oct 21, 2011 6:53 AM by bansalshilpa RSS

    Expression using Rangesum

      Hi,

      My requirement is do do sum of below rows which I am able to achieve partially using following expression.

      Expression for 'Sum Amount' is

      =rangesum(Before(sum(Amount),0,4))

       

      Product

      Month

      201102

      201103

      201104

      201105

      201106

      201107

      201108

      201109

      001801

      Amount

      125464

      152019

      139180

      143548

      153559

      137264

      164853

      314758

      001801

      Sum Amount

      125464

      277483

      416663

      560211

      588306

      573551

      599224

      770434


      But this expression considers only those months which are selected in the report. For ex if I select months from 201103 to 201109, expression doesn't consider month 201102.

       

       

       

      Product

      Month

      201103

      201104

      201105

      201106

      201107

      201108

      201109

      001801

      Amount

      152019

      139180

      143548

      153559

      137264

      164853

      314758

      001801

      Sum Amount

      152019

      291199

      434747

      588306

      573551

      599224

      770434

       

      My requirement is to get following even if selection is made on month

       

       

      Product

      Month

      201103

      201104

      201105

      201106

      201107

      201108

      201109

      001801

      Amount

      152019

      139180

      143548

      153559

      137264

      164853

      314758

      001801

      Sum Amount

      277483

      416663

      560211

      588306

      573551

      599224

      770434

       

      Can some explain me if I can achieve this at front end level, if not how to define this at script level.

      rangesum(Before(sum(Amount),0,4)) doesn't work at script level.

       

      Thanks a lot for your help

      Regards

      Shilpa