Apply summary function to each record in group.
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.
(ISSNAM rec mode) MOODID (PORT in 'D1')
(LeftArg) ((GroupField rec SumFnRightArg)) RightArg
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 |
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 |
Type: Text, Boolean, Numeric, Date
Result of summary function for each group.