Is there a way to use data of previous column?

[that_anonymous_guy]

I have a column(Field1). I want a calculated field(Diff) which will give the difference between the previous two values in the previous row. 

Field1	Diff
5%	5%
12%	7%
14%	2%
19%	5%
24%	5%

Is there a way to do this in the table(front end) or else in the script?

[MayilVahanan]

Hi

In Script, use previous or peek function, in front end, try with above()

Like

Load Field1, Field1 - Alt(Previous(Field1),0)  as Diff from yourtable;

[that_anonymous_guy]

Hi 

Thank you for your response but above is only picking value from the its own column but I want to peek value from other column...something like hlookup in excel