Count

[#1]

Trying to Count the number of Yes's in a Field [Dynamic 2017 (Y/N)]... keep getting error message.

Count({$<[Dynamic 2017 (Y/N)]={'Y'}>})

[oknotsen]

And what is the error message that you are getting?

What I notice is that your expression is missing the actual field to count. It seems to only contain the Set Analysis section.

Try this:

Count({$<[Dynamic 2017 (Y/N)]={'Y'}>} [Dynamic 2017 (Y/N)])

[khan_imran]

try this one -

=Count({$<[Dynamic 2017 (Y/N)]={'Y'}>} Distinct [Dynamic 2017 (Y/N)])

this will give you unique count. First try it in the text object for testing then place it anywhere