sum_where
Conditionally sum a field expression in SSRS, adding values only when a condition is met.
Instructions
Emit =Sum(IIf(, <field_expression>, 0)) — the SSRS conditional-sum idiom. Both args are expression bodies (no leading '=').
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": {
"field_expression": "<field_expression>",
"condition": "<condition>"
},
"name": "sum_where"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| condition | Yes | RDL expression body, e.g. 'Fields!Status.Value = "Active"'. | |
| field_expression | Yes | Value to sum, e.g. 'Fields!Amount.Value'. |