FieldValueCount() is an integer function that finds the number of distinct values in a field.
Syntax:
FieldValueCount(field_name)
Arguments:
| Argument | Description |
|---|---|
| field_name | Name of the field for which the value is required. Must be given as a string value. This means that the field name must be enclosed by single quotes. |
Examples and results:
The following example uses two fields: First name and Initials.
| Examples | Results |
|---|---|
|
FieldValueCount('First name') |
5 as Peter appears twice. |
|
FieldValueCount('Initials') |
6 as Initials only has distinct values. |
Data used in example:
| First name | Initials |
|---|---|
| John | JA |
| Sue | SB |
| Mark | MC |
| Peter | PD |
| Jane | JE |
| Peter | PF |