4 Replies Latest reply on Jan 28, 2014 2:23 PM by philmodjunk

PatternCount for "Males" counts "Females"

NonProfitEducationUser Jan 28, 2014 12:36 PM

Title

Post

I have a tabbed layout set up for programming. One of the tabs is roster- which is a portal to the student's information. The other contains all the information for the group as a whole.

I want to be able to get a total count of males and a total count of females, without having to using a report (so that I can put this information on the group's main page) I am currently using PatternCount in a field to yeild a "1" or a "0" and then using a seperate summary feild to get those totals.

Works perfectly with females, but "Males" returns all the those marked as "Females" as well. Am I missing a notation to have it only return exact phrases? I even tried to change the input method to radio buttons to see if there was an error in the way "Male" or "Female" was input by the user, but that didn't help either.

Here is my calculation:

Case ( PatternCount ( Participants::PartGender ; "Males" ) ; 1 )

It also still returns the total count when I add in a / ; 0 / to the end of the equation.

I'm sure I'm overlooking something simple here, but just can't figure it out. Thanks for any suggestions!

1. Re: PatternCount for "Males" counts "Females"

IT_User Jan 28, 2014 12:47 PM (in response to NonProfitEducationUser)

     Since you use a radio button and people don't type in the input, then you can use:

     Case ( Participants::PartGender = "Males" ; 1 )

     instead of patterncount, because patterncount will find it true if it finds the phrase in the middle of something else, not just exact phrases.
Like Show 0 Likes(0)

Actions
2. Re: PatternCount for "Males" counts "Females"

NonProfitEducationUser Jan 28, 2014 1:36 PM (in response to NonProfitEducationUser)

It is still returning the females in that count. What am I doing wrong?
Like Show 0 Likes(0)

Actions
3. Re: PatternCount for "Males" counts "Females"

IT_User Jan 28, 2014 2:03 PM (in response to NonProfitEducationUser)

Probably shouldn't affect this, but is the calculation field stored or unstored?
Like Show 0 Likes(0)

Actions
4. Re: PatternCount for "Males" counts "Females"

philmodjunk Jan 28, 2014 2:23 PM (in response to NonProfitEducationUser)

     The method ID_User describes should work. Here's an alternative approach:

     Define a "count of" summary field in the Student table and set it to count a field in the table that is never empty.

     Make a copy of your portal and modify this copy as follows:

     Reduce it to a single portal row.
     Add this portal filter expression:

     Participants::PartGender = "Male" //Like IT_User I am assuming that Participants is the name of the portal's table occurrence.

     Put the "count of" summary field as the lone field in this single row portal.

     Repeat the process but use "Female" instead of "Male" in the filter expression.

     You should now have two one row filters that give you male and female counts.
Like Show 0 Likes(0)

Actions

Go to original post