Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use rangesum(), like:
RangeSum(Field1, Field2,....Fieldn)
Or,
Simply Field1+Field2+...fieldn
You could try adding them one at a time to debug it. Sum() isn't required you can just add them up.
Richard
Hi,
Just use
Column()
Like,
Column(1)+Column(2)+Column(3)+etc
Regards,
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))
Hi Mafaz.
You may want to do the sum in the script.
Good luck.
column() will only work if all fields are specifically used as expressions in a chart.
I agree, except use RangeSum() rather than NumSum(). NumSum() is deprecated and will disappear in future, RangeSum() is the replacement for NumSum()
NumSum() does exactly the same thing like RangeSum(). In addition to that, the outer sum() you added is redundant.
can any one replay below link