patterncount help

[mcbradford]

I have four fields, each uses the same value list. The choice are "y", "n", "l" (by radio buttons).

 

I want to count the "y", "n", "l" across the four fields.

 

My pattern count is not working??? Perhaps pattern count is not the best option??? Any ideas? There must be a better way than a V E R Y long case statement :-)

[mcbradford]

(PatternCount(system1,"y" )) + (PatternCount(system2,"y" )) + (PatternCount(system3,"y" )) + (PatternCount(system4,"y" ))

 

This works - does this seem the best way?

[Ender]

You could concatonate the fields first, then count the y's:

 

patterncount ( system1 & system2 & system3 & system4, "y" )

 

However, if you have a lot of these fields (system1, system2, etc.,) then you may be better off using a related file for the system questions, and then counting the y's through the relationship.