Single Quotes in Set Analysis

[#1]

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.

[JonnyPoole]

try using chr(39) as follows:

sum(  {$<NameField={$(='Example' &chr(39)&'s')}>} Sales)

[maxgro]

using double quotes

sum({$ <NameField={"Example's"}>} Sales)

[#4]

But I wanted to throw this example a calculated dimension.

[JonnyPoole]

Can you post the Calculated Dimension formula you are working on ? 

replace() and purgechar() are also helpful functions here, but specifics are important.