Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi gays !!!!
I can help on how to convert this string
ALESE, AUTOLAND
in
'ALESE','AUTOLAND'
in set analisys please
Atte. Fabio
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...
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...
Thanks man.
Thanks man !!!
=Chr(39)&Replace('ALESE, AUTOLAND',',',Chr(39)&','&Chr(39))&Chr(39)
Thank's man
You're welcome
regards
Marco