cumulative Multiple each value from previous date to present

phongnnguyen — Fri, 02 Apr 2021 07:42:58 GMT

Hi everybody,

I want to show the result like below example:

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

Re: cumulative Multiple each value from previous date to present

tresB — Wed, 05 Dec 2018 09:38:33 GMT

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
]