The built-in functions work, but the syntax is very counter-intuitive IMHO.
(MINIMUM MAXIMUM AVERAGE TOTAL COUNT BY ttTest.Itemno).ĪCCUM MINIMUM BY ttTest.ItemNo ttTest.QuantityĪCCUM MAXIMUM BY ttTest.ItemNo ttTest.QuantityĪCCUM AVERAGE BY ttTest.ItemNo ttTest.QuantityĪCCUM TOTAL BY ttTest.ItemNo ttTest.QuantityĪCCUM COUNT BY ttTest.ItemNo ttTest.Quantity Then, the actual reporting part: FOR EACH ttTest So, here's the solution using the built-in aggregation functions of Progress.įirst, some housekeeping: setting up the temp-table and filling it: DEFINE TEMP-TABLE ttTestĭEFINE INPUT PARAMETER pcItem AS CHARACTER NO-UNDO.ĭEFINE INPUT PARAMETER piQty AS INTEGER NO-UNDO.
