CAS 6


recmax
- Miscellaneous

Summary

Get maximum value for all records with the same key.

Description

Note: This produces a result for EVERY record that is a function of the other records.

Examples

recmax MTDATE LOANID

Syntax

recmax NumField KeyField

Right Arguments

Name Data Type Input Type Description Optional Default
NumField Numeric Field No
KeyField Numeric Field No

Result

Type: Numeric

Maximum of all record values with same key



Build 6.0.624