aggregate_records
Compute aggregates such as sum, average, min, max, median, and count on numeric fields from Oracle Fusion records. Uses exact decimal arithmetic to avoid float drift on currency values.
Instructions
Compute an aggregate (sum, avg, min, max, median, count, count_nonnull) over a numeric field in a list of records. Use this for ANY arithmetic on Oracle Fusion data — do NOT compute sums, averages, or counts yourself. All math uses exact Decimal arithmetic to avoid float drift on currency values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| field | Yes | Field name to aggregate (e.g. 'InvoiceAmount', 'TotalAmount'). | |
| records | Yes | Array of record objects from a previous search tool call. | |
| operation | Yes | Aggregation operation. | |
| decimal_places | No | Decimal places for rounding (default 2). |