CAS 6

User function: percent

Calculate the percentage of total of current group. The first optional selection criteria modifies the NUMERATOR. The second optional selection criteria modifies the DENOMINATOR

^*Function is a "column oriented" percentage, and as as such is additive. See function 'pct' for "row oriented" percentage.

^*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.

Example

percent CURBAL 
percent CURBAL (DELQ eq 1) 
percent CURBAL (DELQ eq 1) (DELQ eq 1)
percent CURBAL (DELQ eq 1) (DELQ gt 0)

Text Field, based on number of records:

percent LOANID

Text Field, based on number of records:

percent NAME (STATUS in 'C')

Syntax

percent (NumField∣TextField) [(BoolExpr1) [(BoolExpr2)]]

Right Arguments

Name	Type	Description	Optional
NumField	Numeric Field	Percentage based on total	False
TextField	Text Field	Percentage based on number of records	False
BoolExpr1	Boolean Expression	Selection Criteria for numerator	True
BoolExpr2	Boolean Expression	Selection Criteria for denominator	True

Result

Percentage of total of current group; Numeric String Percentage