Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
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
];