Returns the percent of the total numeric values of a field.
clause calculates the percentage of the overall total for a numeric field. Fields containing nonnumeric values or NULL comprise 0 percent of the total.
Multiple CMQL clauses may be specified in any order. The order of application of CMQL clauses is always the same. The PCT
clause is applied after the WITH
clause, the SAMPLED
clause (if present), and the SAMPLE
clause (if present).
The following example returns the percent of total for each distinct F5 value. Note that non-numeric values are returned as 0%. The WITH
clause eliminates records which have no value (null) for F5:
LIST VOC WITH F5 BY F5 BREAK.ON F5 PCT F5 DET-SUPP
© 1997-2019 InterSystems Corporation, Cambridge, MA