Formula Query - How to 'Count' return values
Hi, Two questions, which are probably a very new-user questions, but I'm stumped. I'm trying to build a summary table that uses formula queries to refer to data in other tables. Question 1: I...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry changing Count to Size
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hi Mark,
Thank you - that results in a syntax error that I don't understand.
For the fields that are just 'counting' (there are 11 of those) - I could create a new formula field that makes those all checkboxes rather than their current text entries, in which case size would work and return back to me the variable I need... So, that's one workaround I can think of.
For the field where I need to count the number of unique communities (for example, 100 events may have 20 communities represented) - size also just returns a syntax error. Is there another way to go about this?
Thank you!!
------------------------------
Jennifer Juhasz
------------------------------
Thank you - that results in a syntax error that I don't understand.
For the fields that are just 'counting' (there are 11 of those) - I could create a new formula field that makes those all checkboxes rather than their current text entries, in which case size would work and return back to me the variable I need... So, that's one workaround I can think of.
For the field where I need to count the number of unique communities (for example, 100 events may have 20 communities represented) - size also just returns a syntax error. Is there another way to go about this?
Thank you!!
------------------------------
Jennifer Juhasz
------------------------------
- Hi - I was able to answer the first part of my question by
1) Converting the text field responses in a field to checkboxes
2) Summing those values
and even determined how to sort a bit deeper to confirm registered guests matching those parameters actually attended an event. That definitely made me happy!
So - now I just need to figure out how to 'count' the number of unique instances of a community occur within the given time frame. Is there a formula that will let me do that?
------------------------------
Jennifer Juhasz
------------------------------