Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm doing a SET at scale analysis of a table:
= NameField = 'Example's'
How do I igonrar the single quotes between the E and S?
Thank's.
try using chr(39) as follows:
sum( {$<NameField={$(='Example' &chr(39)&'s')}>} Sales)
using double quotes
sum({$ <NameField={"Example's"}>} Sales)
But I wanted to throw this example a calculated dimension.
Can you post the Calculated Dimension formula you are working on ?
replace() and purgechar() are also helpful functions here, but specifics are important.