Show TOC

Function documentationTotalizer Locate this document in the navigation structure

 

This action is used to calculate totals or accumulate related information about a record set on a row-by-row basis.

Features

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 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.

      End of the note.

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.