AnsweredAssumed Answered

PatternCount for "Males" counts "Females"

Question asked by NonProfitEducationUser on Jan 28, 2014
Latest reply on Jan 28, 2014 by philmodjunk

Like • Show 0 Likes0
Comment • 4

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!

No one else has this question

Outcomes

IT_User Jan 28, 2014 12:47 PM

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.

Actions

NonProfitEducationUser Jan 28, 2014 1:36 PM

It is still returning the females in that count. What am I doing wrong?

Actions

IT_User Jan 28, 2014 2:03 PM

Probably shouldn't affect this, but is the calculation field stored or unstored?

Actions

philmodjunk Jan 28, 2014 2:23 PM

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.

Actions

4 Replies

IT_User Jan 28, 2014 12:47 PM
Mark Correct
Correct Answer
     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 Likes0
Actions
NonProfitEducationUser Jan 28, 2014 1:36 PM
Mark Correct
Correct Answer
It is still returning the females in that count. What am I doing wrong?
Like • Show 0 Likes0
Actions
IT_User Jan 28, 2014 2:03 PM
Mark Correct
Correct Answer
Probably shouldn't affect this, but is the calculation field stored or unstored?
Like • Show 0 Likes0
Actions
philmodjunk Jan 28, 2014 2:23 PM
Mark Correct
Correct Answer
     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 Likes0
Actions

PatternCount for "Males" counts "Females"

Title

Post

Outcomes

Related Content

Recommended Content