Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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.