8 Replies Latest reply: Dec 22, 2011 4:34 AM by Oronzo Lezzi RSS

    recursive sum

      ThanksHello to everybody

       

      I need to have a calculate columns starting from 2 columns

       

       

      A
      BCn
      01001001
      2001202
      3001503
      1001604
      1001705

       

       

      if A=0

       

      C=B

       

      if  A <> 0  C=A+C(n-1)

       

      I have tried an Expression like this

       

      if(A=0, B,rangesum( A,above(C,0,RowNo()) ) )

       

      but it doesn't works.

       

      Does anyone have any suggestions for me?

       

      Thanks

      Oronzo