Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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) )
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) )
Maybe:
SALES+GOODS +OTHERS-NOTSOLD
Thanks. That's right
Thanks.