try this:

IF SUM([Sales]) = 0 THEN 1

ELSE 0

END

That should give you a count of all of the 0's

Or, depending on what you are trying to do:

countd(if [Sales]= 0 then [Name] end)

Couple questions,

What's the error you're seeing?

What dimensions are on your worksheet?

What should the final worksheet look like?

Mahesh,

make a calculated field:

Count of Zero: Count(IF [Sales]=0 THEN 1 END)

and put it in text, you will get it.

Thanks,

Michael

Ray,

You cannot use countd(), otherwise, no matter how many zero's, it always show 1. You should use Count().

Thanks,

Michael

I was counting distinct Names with 0 Sales, not distinct Sales with 0 Sales...

Ray,

Using countd(Name), if there are several records for Name A with several zero sales, it will be wrong.

The sample data is not stored in a standard table because there is no primary key(PK). For a relational database table, there should be a PK with Order ID(or Record ID, something like that), then it is possible and reasonable for a same name with several 0 sales records. Therefore, countd(name) may lead to a wrong result. 

Michael   

Okay, I was assuming unique name, but I concede the point.

Mashesh,

make a calculated field:

Count of Zero:

Count(IF [Sales]=0 THEN 1 END)

and put it in text, you will get it.