Expression in straight table not working?

[#1]

HI,

I have straight table in qvw as below

REGION	SALES	GOODS	OTHERS	NOT SOLD	Overall Total
XX	769.42	310.11		0
YY	168909.34	4515.62		173424.96
ZZ	638850.31	188333.04		446830.73
AA	0	267286.69		726137.32

Dimension : REGION

Expr 1 : SALES

Expr 2 : GOODS

Expr 3 : OTHERS

Expr 4 : NOTSOLD

when I am trying to calculate Overall Total =

Column (1)+Column (2)+Column (3)-(Column (4))

it is showing blank values. Is there any wrong in expression?

please can anyone suggest me.

Thanks.

[swuehl · Accepted solution]

OTHERS lines are NULL?

Then you need rangesum() to add up (or better, use rangesum() anyway):

=Rangesum(column(1),column(2),column(3), -column(4) )

[robert_mika]

Maybe:

SALES+GOODS +OTHERS-NOTSOLD

[#4]

Thanks. That's right

[#5]

Thanks.