GetExcludedCount
GetExcludedCount() finds the number of excluded distinct values in the identified field. Excluded values include alternative (white or light yellow), excluded and selected excluded (gray) fields.
Syntax:
GetExcludedCount (field_name)
Return data type: string
Arguments:
- field_name: The field containing the range of data to be measured.
Examples
The following example uses three fields loaded to different list boxes, one for First name , one for Last name, and one for Initials.
Example 1: no values selected in First name
GetExcludedCount (Initials) = 0
There are no selections.
Example 2: John selected in First name
GetExcludedCount (Initials) = 5
There are 5 excluded values in Initials with gray color. The sixth cell (JA) will be white as it is associated with the selection John in First name.
Example 3: John and Peter selected in First name
GetExcludedCount (Initials) = 3
John is associated with 1 value and Peter is associated with 2 values, in Initials.
Example 4: John and Peter selected in First name, Franc selected in Last name
GetExcludedCount ([First name]) = 4
There are 4 excluded values in First name with gray color. GetExcludedCount() evaluates for fields with excluded values, including alternative and selected excluded fields.
Example 5: John and Peter selected in First name, Franc and Andersonselected in Last name
GetExcludedCount (Initials) = 4
There are 4 excluded values in Initials with gray color. The other two cells (JA and PF) will be white or light yellow as they associated with the selections John and Peter in First name.
Example 6: John and Peter selected in First name, Franc and Anderson selected in Last name
GetExcludedCount ([Last name]) = 4
There are 4 excluded values in Initials. Devonshire, Brown, Carr, and Elliot have gray color.
Data used in example:
Names:
LOAD * inline [
"First name"|"Last name"|Initials|"Has cellphone"
John|Anderson|JA|Yes
Sue|Brown|SB|Yes
Mark|Carr|MC |No
Peter|Devonshire|PD|No
Jane|Elliot|JE|Yes
Peter|Franc|PF|Yes ] (delimiter is '|');