14 Replies Latest reply: Jul 22, 2015 10:57 AM by Steven Grice

# Function for estimating the number of values

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.

Marina

• ###### Re: Function for estimating the number of values

Count(DISTINCT Field)

• ###### Re: Function for estimating the number of values

Sunny, great, thanks!

• ###### Re: Function for estimating the number of values

No problem at all

• ###### Re: Function for estimating the number of values

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

• ###### Re: Function for estimating the number of values

Try this:

Count(DISTINCT If(IsNum(Field), Field))

• ###### Re: Function for estimating the number of values

Sunny, thanks muchly!!!

• ###### Re: Function for estimating the number of values

Another possible solution could be:

=NumCount(\$(=Concat(DISTINCT Field, ',')))

• ###### Re: Function for estimating the number of values

NumericCount(distinct Name)

• ###### Re: Function for estimating the number of values

Count(DISTINCT FieldName)

• ###### Re: Function for estimating the number of values

Borja, thanks!

• ###### Re: Function for estimating the number of values

=Count(Distinct Field)

• ###### Re: Function for estimating the number of values

K N, than you!

• ###### Re: Function for estimating the number of values

Hi Maina