This content has been marked as final.
Show 14 replies

Re: Function for estimating the number of values
Sunny Talwar Jul 22, 2015 6:55 AM (in response to Marina Mezerova)Short answer
Count(DISTINCT Field)

Re: Function for estimating the number of values
Marina Mezerova Jul 22, 2015 7:12 AM (in response to Sunny Talwar )Sunny, great, thanks!

Re: Function for estimating the number of values
Sunny Talwar Jul 22, 2015 7:14 AM (in response to Marina Mezerova)No problem at all


Re: Function for estimating the number of values
Marina Mezerova Jul 22, 2015 7:54 AM (in response to Sunny Talwar )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
Sunny Talwar Jul 22, 2015 7:57 AM (in response to Marina Mezerova)Try this:
Count(DISTINCT If(IsNum(Field), Field))

Re: Function for estimating the number of values
Marina Mezerova Jul 22, 2015 10:56 AM (in response to Sunny Talwar )Sunny, thanks muchly!!!


Re: Function for estimating the number of values
Sunny Talwar Jul 22, 2015 8:03 AM (in response to Marina Mezerova)Another possible solution could be:
=NumCount($(=Concat(DISTINCT Field, ',')))

Re: Function for estimating the number of values
Sasidhar Parupudi Jul 22, 2015 8:11 AM (in response to Marina Mezerova)NumericCount(distinct Name)



Re: Function for estimating the number of values
Borja Borkovich Jul 22, 2015 6:54 AM (in response to Marina Mezerova)Count(DISTINCT FieldName)

Re: Function for estimating the number of values
Marina Mezerova Jul 22, 2015 7:13 AM (in response to Borja Borkovich)Borja, thanks!


Re: Function for estimating the number of values
Kalyan Navuluri Jul 22, 2015 6:55 AM (in response to Marina Mezerova)=Count(Distinct Field)

Re: Function for estimating the number of values
Marina Mezerova Jul 22, 2015 7:13 AM (in response to Kalyan Navuluri)K N, than you!


Re: Function for estimating the number of values
Sasidhar Parupudi Jul 22, 2015 10:29 AM (in response to Marina Mezerova)Hi Maina
Please close the thread if you got your answer
Sasi

Re: Function for estimating the number of values
Steven Grice Jul 22, 2015 10:57 AM (in response to Marina Mezerova)If in Script you can use FieldValueCount(FieldName)