Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Jason, then you can use the '*' parameter only in the category field:
=num(sum({$<[Record Type]=,[Category] *= {'Events'}>} [Qualified]),'##,###.')
Hi Jason, I think is because the $* in the first expression, not because of the specific category
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
Hi Jason, then you can use the '*' parameter only in the category field:
=num(sum({$<[Record Type]=,[Category] *= {'Events'}>} [Qualified]),'##,###.')
Hi,
It is working.
=num(sum({$*<[Record Type]=,[Category] = {'Events'}>} [Qualified]),'##,###.')
Perfect, thanks Ruben!