Compounded Value

[Anonymous]

If I have a dataset as follows per below, how can define the Value for any particlar record. In Excel it is pretty striaght forward to defince value as the PreviousCellAbove*(1+r(i)).

Can I use Above to achieve this?

[Gysbert_Wassenaar]

I don't know if you can do it with above. Somehow I doubt it. But it's pretty easy to do in the script with the peek function: if(rowno()=1,1,peek(Value))*(1+Rate)*100 as Value

[Anonymous]

Thanks Gysbert - that's good to know.

Does it work when the Value is an expression? For example something like Peek(if (SUM(Value)=0,0, SUM(Value))?

Does Value have to refer to the data field that is loaded or can it refer to the Expression?

So for example if I load the data field value and I have an expression called Total Value on the chart that is If(SUM(Value)=0,0, SUM(Value)). Do I use Peek(Total Value) or Peek(if (SUM(Value)=0,0, SUM(Value))?