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.

Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.