Operations with Two Fields From List Items
Subtract, multiply, divide or add two fields from a list item and sum/multiply all the values.
Perform arithmetic operations (subtract, multiply, divide, or add) between two fields in each item of a list, and aggregate the results using a specified operation.
Overview
The Operations with Two Fields From List Items feature allows performing field-level arithmetic operations within list items and then aggregating the results across the list. This is useful for advanced calculations such as weighted sums or averages.
Inputs
| Name | ID | Description |
|---|---|---|
| List | list | The input list of items. |
| First Field JSON Path | firstFieldPath | The JSON path pointing to the first field (e.g., minuend, numerator). |
| Second Field JSON Path | secondFieldPath | The JSON path pointing to the second field (e.g., subtrahend, denominator). |
| Fields Operation | fieldsOperation | The operation to perform between fields: subtraction, multiplication, division, or addition. |
| Items Operation | itemsOperation | The operation to aggregate results across items: multiplication or addition. |
Outputs
| Name | ID | Description |
|---|---|---|
| Success | success | Boolean indicating whether the operation was successful. |
| Result Value | result | The aggregated result of the operation. |
Notes
- Ensure the JSON paths for both fields are valid for all objects in the input list.
- Division by zero in field operations will result in errors.
- Action ID for this operation:
566f4705-203e-4649-8ab5-df5ff2edcc26.
Updated 3 days ago