CAS 6

percentc
- Group

Summary

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.

Description

Note: This is a 'column oriented' percentage, and as such is additive.

See the function 'pct' for a 'row oriented' percentage.

Examples

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')

Syntax

percentc (NumField∣TextField) (BoolExpr1) (BoolExpr2)

Right Arguments

Name	Data Type	Input Type	Optional
NumField	Numeric	Field, Constant	Yes
TextField	Text	Field, Constant	No
BoolExpr1	Boolean	Field, Constant	Yes
BoolExpr2	Boolean	Field, Constant	Yes

Result

Type: Numeric

Percentage of total of current group