Set analysis with % sign

[ccifaldi]

Hello! I have am trying to use set analysis but my field value contains a percent sign. What is the workaround for this? 

Count({<Name={'Name'},Question={'Question'},Response={'100%'}>} Response)

I have tried '100*', "100%", "100*",'*100*' and none have worked. Thanks! 

[KGalloway]

Could you try the following?

Count({<Name={'Name'},Question={'Question'},Response={'100$(=chr(37))'}>} Response)

The $(=chr(37)) part inserts a '%' character into the string you're comparing against Response.

[ccifaldi]

Updating to 

Count({<Name={'Name'},Question={'Question'},
Response={'100$(=chr(37))'}>} Response)

yields a null result unfortunately. Maybe I still have the syntax wrong?

[KGalloway]

Could you provide some example data? I would be able to test it better if I had a few rows, some which should be counted under the set analysis and some which should not.

[rubenmarin · Accepted solution]

Hi, maybe the value stored in the field is a number, the % is just in the presentation layer, in that case the number would be a simple '1': Count({<Name={'Name'},Question={'Question'},Response={'1'}>} Response)