Help on aggr function

[#1]

Hi,

How to show the number of countries which don't have any sales on that day.

Data:

Date     Country     Sales    

1-July      A     100

1-July     B     0

1-July     C     200

2-July     A     0

2-July     B     0

2-July     C     100

Output:

Date     No sales(No.of.Countries)

1-July     1

2-July     2

[cesaraccardi]

Hi, you could try:

count({$<Country={"=sum(Sales)=0"}>} Country)

[swuehl]

Try

=sum( aggr( if(sum(Sales)=0,1,0),Country, Date))