Expression error

[#1]

Dear All,

My Table like below,

BCOD	GRO_PRE	GRO_PRE2013	GROWTH
B100	19680838	17654977	0
BA00	52404853	49525432	0
BB00	13496248	8713215	0
BW00	63788987	56007141	0
MN00	15523671	12800484	0
NE00	48696306	47316803	0
PS00	14029948	11379238	0
WW00	10906811	8771312	0
Total	238527663	212168602	0

I want to calculate the growth. the expression I have used is as follows.

SUM('GRO_PRE'-'GRO_PRE2013')*100/GRO_PRE2013

But output was not calculated.

Please help in this regard.

Regards,

Priyantha

[its_anandrjs]

You can use at is the label name that you provide to the expressions GRO_PRE and GRO_PRE2013 in the formula which is refers the expressions.

SUM("GRO_PRE" - "GRO_PRE2013" )*100 / "GRO_PRE2013"

Regards

Anand