Jump to content

Sum column of found set without relationship of sum field


 Share

This topic is 4374 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4374 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.