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
Please sign in to leave a comment.