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

[#2]

Hi,

Try this it will work

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

[MK_QSL]

Try

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

Or

NUM(((SUM(GRO_PRE)-SUM(GRO_PRE2013))/GRO_PRE2013),'#0.00%')

[#4]

Attached

[#5 · Accepted solution]

Hi Priyantha,

An optimal way to calculate the growth would be:

sum(GRO_PRE) / sum(GRO_PRE2013) - 1

[Anonymous]

Hi,

your  problem is the qoutes.

[#7]

Hi Jannet,

I used the quotes due to  "GRO_PRE" and the "GRO_PRE2013" are also calculated though expressions.

Regards,

Priyantha.

[anbu1984]

Are these "GRO_PRE" and the "GRO_PRE2013" label names of expressions?

[its_anandrjs]

Try like below expression and remove single quotes but you can use double quotes

SUM(GRO_PRE - GRO_PRE2013 )*100 / GRO_PRE2013

Or

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

Where you get error in the expression

Regards

Anand

[#10]

YES