cumulative Multiple each value from previous date to present

[phongnnguyen]

Hi everybody,

I want to show the result like below example:

Date	Cash	Change	Value
1/1/2018	100	0.1	=100*0.1
2/1/2018	120	0.5	=100*0.1+120*0.5
3/1/2018	150	0.4	=150*0.4+100*0.1+120*0.5

Please help me if you have any solution, thanks so much

[tresesco]

Try like:

Load *,
	 Cash*Change+Alt(Peek(Value),0) as Value
	 Inline [
Date,	Cash,	Change
1/1/2018,	100,	0.1
2/1/2018,	120,	0.5
3/1/2018,	150,	0.4
]