Set Analysis with Apostrophe

[#1]

Hi Guys

I have a field called 'Category':

In this field i have text called: SR'S OPEN.

Im trying to perform a set analysis:

=Sum({$<[Category]={'SR' & chr(39) & 'S OPEN'}>} Data)

but this does not work. I think its the apostrophe that erroring.

Any suggestions?

Regards,

Magen

[maxgro · Accepted solution]

maybe

=Sum({$<[Category]={"SR'S OPEN"}>} Data)

[PrashantSangle]

Hi,

It work inside ""

Try like

"SR's Open"

Regards

[#4]

Please try like this,

=Sum({$<[Category]={'SR''S OPEN'}>} Data)

Regards,

Faisal