Show Specific Data in Text Object While Ignoring Filter

[#1]

Hello,

I am having trouble ignoring a specific filter (Record Type) when including a specific Category in my expression:

=num(sum({$*<[Record Type]=,[Category] = {'Events'}>} [Qualified]),'##,###.')

when using it without a specific category, this works fine:

=num(sum({<[Record Type]=>}[Qualified]),'##,###.')

What is wrong with my expression?

Thanks in advance!

-Jason

[rubenmarin]

Hi Jason, I think is because the $* in the first expression, not because of the specific category

[#3]

Hi Ruben,

Removing the $* fixes the issue of ignoring the Record Type filter but I originally had to put that in because If I selected a different Category such as Telemarketing, the actual # of Qualified within Events would still show up rather than 0

[rubenmarin · Accepted solution]

Hi Jason, then you can use the '*' parameter only in the category field:

=num(sum({$<[Record Type]=,[Category] *= {'Events'}>} [Qualified]),'##,###.')

[#5]

Hi,

It is working.

=num(sum({$*<[Record Type]=,[Category] = {'Events'}>} [Qualified]),'##,###.')

[#6]

Perfect, thanks Ruben!