Sum Quantity of Non-Null Records

[jmonroe918]

I have a table similar to the attached spreadsheet.

I am trying to sum the "Qty Affected" column for the records that have an "IssueID" that is not blank or null.

I am having a tough time with the Expression.

Thanks.

Jeff

[sunny_talwar · Accepted solution]

Try this:

=Sum({<IssueID = {"=Len(Trim(IssueID)) > 0"}>}[Qty Affected])

[settu_periasamy]

sunindia‌‌ Attachment is Blank. Can you replace it..

[sunny_talwar]

Thanks Settu‌ for pointing that out . I must have attached it before saving it.

[settu_periasamy]

Yes, i thought so.. 🙂

[jmonroe918]

Thank you Sunny.

Jeff