This action is used to calculate totals or accumulate related information about a record set on a row-by-row basis.
The T otalizeraction has the following modes:
Accumulator
The source column must be a numeric column.
If the current column value is less than the previous value, the accumulator value is calculated as Scaling Factor * [Current Value + (Max Range -Last Value)]. If the current column value is greater than the previous values, the accumulator value is calculated as Scaling Factor * (Current Value - Last Value).
If you have increasing values and a scaling factor of one, you get a simple accumulator.
Counter
The source column must be a numeric column.
If the current column value is less than the previous value, the counter value is calculated as Scaling Factor * (Current Value). If the current column value is greater than the previous values, the counter value is calculated as Scaling Factor * (Current Value - Last Value).
If you have increasing values and a scaling factor of one, you get a simple accumulator.
Integral
The source column must be a numeric column or zero is the result.
You calculate this mode value as Scaling Factor * [Time Span since previous Record in seconds *(Current Value - First Value)].
Transitions
The source column can be a numeric or non-numeric column.
If the last value and the current value are equal, the result is zero. Otherwise, the result is one.
If the value is null, a zero is returned.
Time
The source column must be a numeric column. If the column value is not zero, the identified time stamp column interval is calculated using the following algorithm: Scaling Factor *(Current Date - Last Date) in seconds. With a scaling factor of one, it calculates the time since the last record or row.
Note
You can use only one of the Accumulator, Counter, Integral, and Transitions modes on a single data set. The Time mode can be combined with any of the other modes or used independently.
The properties for this action are listed in the following table:
Property | Data Type | Access | Use |
Source | String | In and out | The path to the source XML document. |
Output | XML | In and out | The XML output with the final document. |
Success | Boolean | Out | Indicates whether the action succeeded or failed. If it failed, errors are displayed in the server trace log. |