Expressions tab - Count(Distinct PolicyNumber)

[#1]

On the Expressions tab in the Chart Properties, I am Counting the number of Distinct PolicyNumbers, to get a policy Count.  What can I do to exclude a certain type of policy.  In SQL I would say where Description <> 'Umbrella'.

[#2]

Use set analysis for example count({<PolicyNumber-={'APolicy'}>}distinct PolicyNumber)

[MK_QSL]

Count({<Description -= {'Umbrella'}>}Distinct PolicyNumbers)

or

Count({<Description = {'*'}-{'Umbrella'}>}Distinct PolicyNumbers)

[#4]

This seemed to work.  Thanks

[MK_QSL]

Kindly close the thread by selecting correct/helpful answer

[anbu1984]

Set NullInterpret='';

Load * Inline [

Description,PolicyNumbers

Umbrella,1

Fan,2

,3];

='Set Analysis doesnt include null Description:' & Count({<Description -= {'Umbrella'}>}Distinct PolicyNumbers)

='Set Analysis including null Description:' & Count({1-<Description = {'Umbrella'}>}Distinct PolicyNumbers)

='If:' & Count(Distinct If(Description <> 'Umbrella', PolicyNumbers))