how to sum columns?

[#1]

Hi,

I have several columns as below and I coded following code to sum all the columns but its not working

=sum(YY_CHANGE + CUTTING_SAVE + WRONG_OVER_TRANSFERS + RE_ORDERS + ERP_ISSUES + MOQ + IN_TOLERANCE + WRONG_OVER_TRANSFERS + DUPLICATE_P.O + BUYER_CHANGES + SUPPLIER_DELIVER_MORE + OTHER)

but its not working can any one help me

• YY_CHANGE
• CUTTING_SAVE
• WRONG_OVER_TRANSFERS
• RE_ORDERS
• ERP_ISSUES
• MOQ
• IN_TOLERANCE
• WRONG_OVER_TRANSFERS
• DUPLICATE_P.O
• BUYER_CHANGES
• SUPPLIER_DELIVER_MORE
• OTHER

[tresesco]

use rangesum(), like:

RangeSum(Field1, Field2,....Fieldn)

Or,

Simply Field1+Field2+...fieldn

[richard_pearce6]

You could try adding them one at a time to debug it. Sum() isn't required you can just add them up.

Richard

[PrashantSangle]

Hi,

Just use

Column()

Like,

Column(1)+Column(2)+Column(3)+etc

Regards,

[CELAMBARASAN]

Some field might contain null values. adding with null will become a null

Try like this

=sum(NumSum(YY_CHANGE ,CUTTING_SAVE ,WRONG_OVER_TRANSFERS ,RE_ORDERS ,ERP_ISSUES ,MOQ ,IN_TOLERANCE ,WRONG_OVER_TRANSFERS ,DUPLICATE_P.O ,BUYER_CHANGES ,SUPPLIER_DELIVER_MORE ,OTHER))

[christian77]

Hi Mafaz.

You may want to do the sum in the script.

Good luck.

[simondachstr]

column() will only work if all fields are specifically used as expressions in a chart.

[jonathandienst]

I agree, except use RangeSum() rather than NumSum(). NumSum() is deprecated and will disappear in future, RangeSum() is the replacement for NumSum()

[simondachstr]

NumSum() does exactly the same thing like RangeSum(). In addition to that, the outer sum() you added is redundant.

[#10]

can any one replay below link

http://community.qlik.com/thread/130575