Hi ALL,
This might be an easy question, but for some reason I'm going crazy over it. Say for example, I have a report which is a list of:
Animals, Date Purchased, Age, Weight, Gender, etc.
In the header, I want to insert a calculation where I can state the quantity(count) of each gender. For Example:
Male:12,000
Female:22,000
So for males I would have to look in "gender" column and COUNT everything thats LIKE "M%" and for females, I would have to look in the same column and COUNT everything thats LIKE "F%". But for some reason, I'm not able to use the LIKE command, meaning, its not one of the "Available Components". Please Help Me Out.
THANKS IN ADVANCE!! =)
-Jeff
This might be an easy question, but for some reason I'm going crazy over it. Say for example, I have a report which is a list of:
Animals, Date Purchased, Age, Weight, Gender, etc.
In the header, I want to insert a calculation where I can state the quantity(count) of each gender. For Example:
Male:12,000
Female:22,000
So for males I would have to look in "gender" column and COUNT everything thats LIKE "M%" and for females, I would have to look in the same column and COUNT everything thats LIKE "F%". But for some reason, I'm not able to use the LIKE command, meaning, its not one of the "Available Components". Please Help Me Out.
THANKS IN ADVANCE!! =)
-Jeff