Counting

[fmsimon]

If a field is a text type, and you are restricting it to a value list of "yes" and "no", is there a way of counting the number of records that have "yes" and also counting the number of records that have "no" ?

[Stuart Taylor]

there are many ways of doing this best to post a file so we can understand what your trying to achive.

[Inky Phil]

I would establish a relationship between a global field and the text field.

Count(thisrelationship::thetextfield) will then give you the total of yes's if you set the global to "yes" and the total of no's if you set the global to "no".

This simple formula can then be included in a calc field (unstored) or in a set field script step

HTH

Phil