add_calculated_field
Add a computed field to a dataset using an RDL expression for values not in the source query. Rejects if the field name already exists.
Instructions
Append a calculated to the named dataset. Calculated fields carry an expression () instead of a column reference (); use them for derived fields like Total = Amount * Quantity that aren't in the source query but should be available via Fields!Name.Value. Refuses if a field of the same name already exists.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>",
"dataset_name": "<dataset_name>",
"field_name": "<field_name>",
"expression": "<expression>"
},
"name": "add_calculated_field"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| expression | Yes | RDL expression, e.g. '=Fields!Amount.Value * Fields!Quantity.Value'. | |
| field_name | Yes | ||
| dataset_name | Yes |