CAS 6


rec
- Miscellaneous

Summary

Apply summary function to each record in group.

Description

Note: For better performance with total, max, or min functions use rectotal, recmax or recmin.

This produces a result for every record that is part of the grouping.

Examples

(ISSNAM rec mode) MOODID (PORT in 'D1') 

Syntax

(LeftArg) ((GroupField rec SumFnRightArg)) RightArg

Left Arguments

Name Data Type Input Type Description Optional Default
LeftArg Text, Boolean, Numeric, Date Field, Constant Left argument to fuction Yes
GroupField Text Field Grouping Field No

Right Arguments

Name Data Type Input Type Description Optional Default
SumFn Text Constant Any summary function No
SumFnRightArg Text, Boolean, Numeric, Date Field, Constant Right argument(s) to SumFnRightArg No

Result

Type: Text, Boolean, Numeric, Date

Result of summary function for each group.



Build 6.0.624