Set Analysis Statement

[Anonymous]

I am sitting here scratching my head.  The following set analysis statement produces an empty string.

=concat({$<CompPoints = {2}>} CompTitle,', ')

The second one produces the string.

=concat({$<CompPoints = {"=2"}>} CompTitle,', ')

[sunny_talwar]

What about if you add single quotes around 2 in your first expression

=Concat({$<CompPoints = {'2'}>} CompTitle,', ')

[marcus_sommer]

The first one compared CompPoints against a numeric 2 and the second one compared CompPoints against a search-string containing 2. If you used single-quotes like '2' the first expression should be work too, whereby it depends on your release and some settings & when the app was created how the single-quotes are interpreted. More to them could you find here: Quotes in Set Analysis.

Edit: Fields which contain values which could be numeric interpreted should be real numbers - this meant not to use '2' anywhere in the script else just 2 and if it's already stored as string it should be converted with functions like num#().

- Marcus