This produces the ratio of two percentages where the Numerator is the percentage:
ratio CURBAL (RATETYPE in 'A') (DELQ gt 1)
pct CURBAL ((RATETYPE in 'A') and (DELQ gt 1)) (DELQ gt 1)
pct CURBAL (RATETYPE in 'A')
ratio (NumField∣TextField) (Numerator) (Denominator)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| NumField | Numeric | Field | Yes | ||
| TextField | Text | Field | Yes | ||
| Numerator | Boolean | Field | Expression to select records that will be applied to the calculation. | Yes | 1 |
| Denominator | Boolean | Field | Expression to select records that will be applied to the calculation. | Yes | 1 |
Type: Numeric
Ratio