Formula using E (exclude)

[#1]

My formula, using E for excluding specific CUST_NO's is not summing the three columns at the end of the formula that I want to Sum.

It is only summing REDI_WEIGHT. Am I missing something? Brackets, parentheses...etc?

Sum({<CUST_NO=E(CUST_NO)-{'20000','26630','32200','50000','61110','71240'}>}(NUMSUM(REDI_WEIGHT)+NUMSUM(DIR_WEIGHT)+NUMSUM(DIR_CN_WEIGHT)))

[swuehl]

That's hard to answer without knowing anything about your data model.

If possible, upload a small sample QVW.

[sunny_talwar]

Can you try this:

Sum({<CUST_NO=E(CUST_NO)-{'20000','26630','32200','50000','61110','71240'}>} RangeSum(REDI_WEIGHT, DIR_WEIGHT, DIR_CN_WEIGHT))