Hi All,
I have 3 columns namely (Date, A,B,C) and I need to fetch previous value in C column and calculate to A, B column value,
example : C2 = C1+A2-B2
pls help me out for calculated field
Hi All,
I have 3 columns namely (Date, A,B,C) and I need to fetch previous value in C column and calculate to A, B column value,
example : C2 = C1+A2-B2
pls help me out for calculated field
You can use a lag function.