Itterative Sum

[#1]

I want to load to do following Sum

Inital Value = 20

ColumnA      ColumnB     Value

Jan                  20              40  //Value is ColumnB+Initial Value

Feb                 30               70  //Value is 40 from above + Column B

Mar                 10               80  //Value is 70 from above + Column B

Apr                  40               120  //Value is 80 from above + Column B

May                 20               140  //Value is 120 from above + Column B

How do I do it? I have ColumnA and ColumnB Loaded, but I want to build the Value Column using sum logic mentioned above.

[swuehl]

Maybe try something along these lines:

LOAD *,

rangesum(if(recno() = 1,20,peek(Value)),ColumnB) as Value

INLINE [

ColumnA,      ColumnB    

Jan,                  20 

Feb,                 30  

Mar,                 10  

Apr,                  40 

May,                 20  

];

[Clever_Anjos]

LET InitialValue=20;

LOAD

  ColumnA,

  ColumnB,

  if(IsNull(Peek('Value')),

  ColumnB + $(InitialValue),

  rangesum(Peek('Value'),ColumnB)

  ) as Value

  ;

LOAD * INLINE [

    ColumnA, ColumnB

    Jan, 20

    Feb, 30

    Mar, 10

    Apr, 40

    May, 20

];