Records in set
Records in set ( set ) : Integer
| Parameter | Type | Description | |
|---|---|---|---|
| set | Text | → | Name of the set to test |
| Function result | Integer | ← | Number of records in set |
Description
Records in set returns the number of records in set. If set does not exist, or if there are no records in set, the command returns 0.
Example
The following example displays an alert telling what percentage of the customers are rated as the best:
// First calculate the percentage
$Percent :=(Records in set("Best")/Records in table([Customers]))*100
// Display an alert with the percentage
ALERT(String($Percent;"##0%")+" of our customers are the best.")