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