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!
Sunny, great, thanks!
No problem at all
I'm so sorry. I forgot to clarify that I need a function for estimating the number of only numeric valeus. Is it possible?
Count(DISTINCT If(IsNum(Field), Field))
Sunny, thanks muchly!!!
Another possible solution could be:
=NumCount($(=Concat(DISTINCT Field, ',')))
K N, than you!
Please close the thread if you got your answer
If in Script you can use FieldValueCount(FieldName)
Retrieving data ...