Subtract Two Rows using expression

[jayaseelan]

Hi Experts,

I need to subtract the two rows and the result should be feed to another column.

I have attached my Data in excel, Please any one give me the solution for attached data.

thanks,

[swuehl]

Try a chart inter record function, Above():

=Rangesum( Value, -Above(Value) )

[sunny_talwar]

In case you have more than Value for each Month, you might need to add Sum() or Avg() or whatever you expression is for value

=RangeSum(Exp4Value, -Above(Exp4Value))

[jayaseelan]

Thanks for your valuable reply

But using above expression i did't getting my result. can you please give me a example .qvw or .qvf use the data which i have attached.

[devarasu07 · Accepted solution]

Hi,

Refer to the attached sample output. tks

[jayaseelan]

Thanks for replied everyone got the output.