topic Re: Need help on Set Analysis in App Development

Need help on Set Analysis

madhudinesh — Sat, 16 Nov 2024 00:17:32 GMT

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

Re: Need help on Set Analysis

Gysbert_Wassenaar — Wed, 07 Apr 2021 13:54:16 GMT

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)

Re: Need help on Set Analysis

madhudinesh — Wed, 07 Apr 2021 14:21:46 GMT

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