Help

[fabio182]

Hi gays !!!!

I can help on how to convert this string

ALESE, AUTOLAND

in

'ALESE','AUTOLAND'

in set analisys please

Atte. Fabio

[JonnyPoole · Accepted solution]

chr(39)  - single quote   AND chr(44) - comma   ...are your friends while using double quotes in your SET MODIFIER.

So something like this

sum( {<RegionString={"$(=chr(39) & 'North America' & chr(39) & chr(44) & chr(39) & 'South America' & chr(39))"}>}  Sales)

will evaluate to:

Sum ( {<RegionString={"  'North America','South America' "}>} Sales)

and only show the result where RegionString is:    'North America','South America'

as below...

[maxgro]

[fabio182]

Thanks man.

[fabio182]

Thanks man !!!

[MarcoWedel]

=Chr(39)&Replace('ALESE, AUTOLAND',',',Chr(39)&','&Chr(39))&Chr(39)

[fabio182]

Thank's man

[MarcoWedel]

You're welcome

regards

Marco