How to add column to existing expression?

[#1]

Hi,

I have below expression in chart

=COUNT({<[Status] -= {'SalesCounter','Ground'}>}DISTINCT CustomerID)

I need to add one more column Region to above expression.

The region have blanks and 3,4. But I need to add only Region =3,4.

How to add the Region to the existing expression? Can anyone suggest me.

Thanks.

[MK_QSL · Accepted solution]

=COUNT({<[Status] -= {'SalesCounter','Ground'}, Region = {'3','4'}>}DISTINCT CustomerID)

[#3]

Thanks. how to change the same expression if I need to show all integers in Region except blanks?

[awhitfield]

=COUNT({<[Status] -= {'SalesCounter','Ground'}, Region = {'*'}>}DISTINCT CustomerID)

[MK_QSL]

Region = {'*'}

or Create below in your script

IF(IsNull(Region) or Len(Trim(Region))=0, 0, 1) as RegionNotNullFlag

Now instead of Region = something......use

RegionNotNullFlag= {'1'}