Count counts all the values in a set of cells, while allcount counts all the cells regardless of content (null-values as well). This can be used to validate if all the wanted/required registrations are present in a dataset.
The formula count(d1, all, m1) % allcount(d1, all, m1) will calculate the percentage of cells in the first column from the left containing numeric values.
Comments
I have a crosstab, but I need cout only the cells whit value 0 of each column
Hi Felipe,
In that case I would introduce "Count flag" columns in the crosstab.
The "Count flag" calculation, as a new measure, can be something like this:
Example, where I also included a Total as a calculated row, sum(0, all, 0):
BR / Ole
Please sign in to leave a comment.