Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Sum({<IssueID = {"=Len(Trim(IssueID)) > 0"}>}[Qty Affected])
Try this:
=Sum({<IssueID = {"=Len(Trim(IssueID)) > 0"}>}[Qty Affected])
sunindia Attachment is Blank. Can you replace it..
Thanks Settu for pointing that out . I must have attached it before saving it.
Yes, i thought so.. 🙂
Thank you Sunny.
Jeff