Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a really short question!
Which function estimates the number of values in a field?
I do not care what is the sum or avg for value, I need only the number of unique values in a field.
Many thanks in advace!
Marina
Short answer
Count(DISTINCT Field)
Count(DISTINCT FieldName)
=Count(Distinct Field)
Sunny, great, thanks!
Borja, thanks!
K N, than you!
No problem at all
Sunny,
I'm so sorry. I forgot to clarify that I need a function for estimating the number of only numeric valeus. Is it possible?
Marina
Try this:
Count(DISTINCT If(IsNum(Field), Field))