1 Reply Latest reply on Dec 23, 2015 1:26 PM by diego.medrano

    lag function

    Beatriz Maria

      HI,

      is there any way i can replace the zeros in a table by adding the value of the following row (is that is not zero)

      i.e. from this:

       

      flagJanuary 2015February 2015March 2015April 2015May 2015June 2015July 2015August 2015September 2015October 2015
      10000000000
      20000000687,82100
      3563,246564647,20259,687259,7741,342,67885,5441,415,424208,442
      435,653,411352,4636,653610,32346,467455,555159,482
      5173,273152,538236,5108,443456,74546,76765,474
      685,69698,790163,1515,454279,73556,341
      749,91370,010126,880142,83523,016
      835,97744,78179,24910,493
      99,56417,0546,497
      10473857
      11

      712

      to:

       

      flagJanuary 2015February 2015March 2015April 2015May 2015June 2015July 2015August 2015September 2015October 2015
      1563,246564647,20259,687259,7741,342,67885,544687,82100
      235,653,411352,4636,653610,32346,467455,5551,415,42400
      3173,273152,538236,5108,443456,74546,76765,474159,482208,442
      485,69698,790163,1515,454279,73556,341
      549,91370,010126,880142,83523,016
      635,97744,78179,24910,493
      79,56417,0546,497
      8473857
      9712
      10

      11

       

       

      Thank you very much in advance