Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How can count number of string , for example , how can i count the number of countries in the list below
You can count the distinct field values like
=COUNT( DISTINCT COUNTRY_AGG)
If you want to count all field records, remove the DISTINCT qualifier from the count.
And if you want to count disregarding any user selections:
=COUNT({1} DISTINCT COUNTRY_AGG)
You can count the distinct field values like
=COUNT( DISTINCT COUNTRY_AGG)
If you want to count all field records, remove the DISTINCT qualifier from the count.
And if you want to count disregarding any user selections:
=COUNT({1} DISTINCT COUNTRY_AGG)