Need help on Set Analysis

[madhudinesh]

Hi All,

I have the field value as below in 'Column A'. While declaring the same in set analysis similar to below, we are not receiving correct results as ' used is considered as delimiter. please help how this can be handled

=Sum({<[Column A] = {'Mark's Studio'}>} Sales) (or) Sum({<[Column A] = {"Mark's Studio"}>} Sales) 

Column A

Mark's Studio

@sunny_talwar 

[Gysbert_Wassenaar · Accepted solution]

You can use different kind of 'quotes'. These should work:

Sum({<[Column A] = {"Mark's Studio"}>} Sales)

Sum({<[Column A] = {`Mark's Studio`}>} Sales)

Sum({<[Column A] = {[Mark's Studio]}>} Sales)

And I think two single quotes in Mark''s should work too: =Sum({<[Column A] = {'Mark''s Studio'}>} Sales) 

[madhudinesh]

Thank you so much for the quick response. These options works 🙂