Aggregate Function not working

[#1]

I have a chart that contains four columns:

     Channel

     Division

     Buying Stores

     Eligible Stores

I would like to count or aggregate Eligible Stores per channel, and per division.

I'm using the aggregate function but it does not return a number when the Buying Stores column is 0. The calculation comes back blank or with a '-' entry.

Where can i find the proper syntax for the Aggr function?

Below is my formula.

=Aggr($(eTotalEligibleStoresProduct),[Channel Description],[Division]) 

[Gysbert_Wassenaar]

The proper syntax can be found in the help file. The proper usage isn't. You may want to read this blog post and the linked documents.