topic Formula using E (exclude) in QlikView https://community.qlik.com/t5/QlikView/Formula-using-E-exclude/m-p/1108171#M366843 <HTML><HEAD></HEAD><BODY><P>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.</P><P>It is only summing REDI_WEIGHT. Am I missing something? Brackets, parentheses...etc?</P><P></P><P></P><P><STRONG> Sum({&lt;CUST_NO=E(CUST_NO)-{'20000','26630','32200','50000','61110','71240'}&gt;}(NUMSUM(REDI_WEIGHT)+NUMSUM(DIR_WEIGHT)+NUMSUM(DIR_CN_WEIGHT)))</STRONG></P></BODY></HTML> Wed, 01 Jun 2016 19:06:35 GMT 2016-06-01T19:06:35Z Formula using E (exclude) https://community.qlik.com/t5/QlikView/Formula-using-E-exclude/m-p/1108171#M366843 <HTML><HEAD></HEAD><BODY><P>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.</P><P>It is only summing REDI_WEIGHT. Am I missing something? Brackets, parentheses...etc?</P><P></P><P></P><P><STRONG> Sum({&lt;CUST_NO=E(CUST_NO)-{'20000','26630','32200','50000','61110','71240'}&gt;}(NUMSUM(REDI_WEIGHT)+NUMSUM(DIR_WEIGHT)+NUMSUM(DIR_CN_WEIGHT)))</STRONG></P></BODY></HTML> Wed, 01 Jun 2016 19:06:35 GMT https://community.qlik.com/t5/QlikView/Formula-using-E-exclude/m-p/1108171#M366843 2016-06-01T19:06:35Z Re: Formula using E (exclude) https://community.qlik.com/t5/QlikView/Formula-using-E-exclude/m-p/1108172#M366844 <HTML><HEAD></HEAD><BODY><P>That's hard to answer without knowing anything about your data model.</P><P></P><P>If possible, upload a small sample QVW.</P></BODY></HTML> Wed, 01 Jun 2016 20:22:43 GMT https://community.qlik.com/t5/QlikView/Formula-using-E-exclude/m-p/1108172#M366844 swuehl 2016-06-01T20:22:43Z Re: Formula using E (exclude) https://community.qlik.com/t5/QlikView/Formula-using-E-exclude/m-p/1108173#M366845 <HTML><HEAD></HEAD><BODY><P>Can you try this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum({&lt;CUST_NO=E(CUST_NO)-{'20000','26630','32200','50000','61110','71240'}&gt;} RangeSum(REDI_WEIGHT, DIR_WEIGHT, DIR_CN_WEIGHT))</STRONG></P></BODY></HTML> Wed, 01 Jun 2016 20:24:57 GMT https://community.qlik.com/t5/QlikView/Formula-using-E-exclude/m-p/1108173#M366845 sunny_talwar 2016-06-01T20:24:57Z