When used in a frequency report, this is a percentage across a row - not up and down the column (see function 'percent'). The first selection statement modifies the numerator, and the second, optional statement modifies the denominator. For a percentage based on number of records, use a character field.
pct CURBAL (PROPTYPE in 'SF,SFD,SFA')
pct CURBAL (OWNOCC in 'P,S')
100 times (total CURBAL (OWNOCC in 'P,S')) divide total CURBAL
pct CURBAL (OWNOCC in 'P') (OWNOCC in 'S')
100 times (total CURBAL (OWNOCC in 'P')) divide total CURBAL (OWNOCC in 'S')
pct InputField (Numerator) (Denominator)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| InputField | Text, Numeric | 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
100 x Selected Records / Total Records