Evaluating a text field to summarize

[agreen10]

I have a text formula field that I would like to summarize on certain values. Eg.

the GE a calculated field which prints either "Below" or "above". I want to create a summary that would count how many time "Below" shows up and how many times, "Above" Shows up. In the GE formula, I had a string that was converted using the tonumber function and when when a try to run a count formula, gets an error message saying that the one of the fields that I converted is nonnumeric.

Is there a nice and efficient way to do this than creating two other formulas which did not quite work right.

 

[synapsevampire]

If the 2 formula method doesn't work, post specifics.

Successful posts tend to include:

Crystal version
Database/connectivity used
Example data (show fields, and sample data)
Expected result from the sample data

Descriptions rarely convey requirements, the above, if done clearly, will define them well.

Your field may have had something like:

if isnumeric({table.value}) then
{table.field}
else
0

and neglected the ELSE 0, or you might not have checked that it always was a value. Obviously your p[ost conveys nothing technical and is destined to be a blog. I think that LB had helped you with the previous post, and it seemed that the solution was solid given the requirements conveyed.

-k

 

[lbass]

Please provide samples of the field, and also be more specific about what you want returned by a formula that references that field. Also explain what it is you are trying to count.

-LB