Data Integration
- Data Integration
- All Products
%OPR_SUM[macro_input_field[,filter_condition] ]%
Argument
| Required/Optional
| Description
|
---|---|---|
macro _input _field
| Required
| Numeric datatype. Passes the values you want to add. You can enter a macro input field or an expression that includes at least one macro input field.
|
filter_condition
| Optional
| Limits the rows in the search. The filter condition must be a numeric value or evaluate to TRUE, FALSE, or NULL. You can enter any valid transformation expression.
|
Q1, Q2, Q3, Q4
%OPR_SUM[ %Sales% ]%
Q1
| Q2
| Q3
| Q4
| RETURN VALUE
|
---|---|---|---|---|
50
| 200
| 50
| 100
| 400
|
100
| NULL
| 100
| 250
| 450
|
500
| 200
| 200
| 200
| 1100
|
NULL
| NULL
| NULL
| NULL
| NULL
|
400
| NULL
| NULL
| 400
| 800
|