Sum column of found set without relationship of sum field

February 15, 201114 yr

I am sure this has been answered thousand time, search sum, found set, is hard to narrow down.

I have my search returned in a list view. some records are tagged with 1. Those are the records I would like a count within a script.

Can this be done without relationships and extra fields?

February 15, 201114 yr

some records are tagged with 1. Those are the records I would like a count

Found set is best summarized by summary fields. If the other records are tagged as <empty>, you can simply count the tag field.

February 15, 201114 yr

Author

Found set is best summarized by summary fields. If the other records are tagged as <empty>, you can simply count the tag field.

Thanks Comment, I was trying to avoid more fields. (trying to keep it lean)

I am running a script and populating variables for display only.

Currently I came up with a solution using two custom functions.

http://www.briandunning.com/cf/1093 - GetFoundSet

http://www.briandunning.com/cf/1116 - SumList

February 15, 201114 yr

Thanks Comment, I was trying to avoid more fields. (trying to keep it lean)

I am running a script and populating variables for display only.

Currently I came up with a solution using two custom functions.

http://www.briandunning.com/cf/1093 - GetFoundSet

http://www.briandunning.com/cf/1116 - SumList

There is a single CF that will do it:

http://www.briandunning.com/cf/1275

February 15, 201114 yr

I was trying to avoid more fields.

So how about:

New Window []

Constrain Found Set [ Speciﬁed Find Requests: Find Records; Criteria: YourTable::Tag: “1” ] 

Set Variable [ $countTagged ; Get (FoundCount) ]

Close Window [Current Window]