Calculate the percentage of total of current group. The first optional selection criteria modifies the NUMERATOR The second optional selection criteria modifies the DENOMINATOR Note: This is a 'column oriented' percentage, and as as such is additive. See the function 'pct' for a 'row oriented' percentage.
Note: Use a text field when getting percentage of buckets. When a numeric field is used the actual values will be used to weight the result.
percent CURBAL
percent CURBAL (DELQ eq 1)
percent CURBAL (DELQ eq 1) (DELQ eq 1)
percent CURBAL (DELQ eq 1) (DELQ gt 0)
percent LOANID
percent NAME (STATUS in 'C')
percent InputField (Numerator) (Denominator)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| InputField | Numeric, Text | Field | No | ||
| 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
Percentage of total of current group