How do we count using multiple Conditions along with null value

[saivina2920]

How do we count using multiple Conditions along with null value ..?

For Example, 

I am counting null value and my expression is below.

1st Expression ==>       =Count(If(Len(Trim([Sales]))=0,[Sales])) 

with the above, i just want to check two more condition as mentioned below.

2nd Expression ==>  ({<[Current Status] = {'*ISSUE FOR CHECK*'}>} DISTINCT [PRODUCT ID NUMBER])

How do we combine 1st and 2nd expression. It means How do we count using multiple Conditions along with null value ..?

[raman_rastogi · Accepted solution]

 May be like this

Count({<[Sales]= {"=len(trim([Sales])) =0"},[Current Status] = {"*ISSUE FOR CHECK*"}>} DISTINCT [PRODUCT ID NUMBER])

[saivina2920]

Excellent...It's working..