Extraction types

Extraction types can be chosen for each field in a query.

Reverse Sign

The Reverse Sign option changes the display of a numeric output from positive to negative, or from negative to positive. For example, £100 is displayed as -£100.

Scaling Factor

The Scaling Factor performs an arithmetical operation on the extracted value. There are seven predefined settings from /10 to /10000000 which scale down the extracted amount by increasing factors of 10. This can be used to change units in executive summary reports, for example, to display $12 000 000 as $12M.

You can add further scaling factors. For example, to specify a currency exchange rate. Assume 1 EURO = $ 1.215 USD. By entering the Scaling Factor ' *1.215 ' the extracted Euro value is converted to US dollars and inserted into the worksheet cell.

Scaling Factor does not perform any rounding, so fractions are retained. For example, 1354.5658 with a Scaling Factor /100 becomes 13.545658.

For accuracy, Scaling Factor is performed on the final summary result and not the individual transactions. Scaling Factor calculations are completed by the server and not the client PC, to maximize performance.


Segment extracts a subsection of an Output Item.

Note: Segments are reserved for alphanumeric fields. Segment functionality cannot be applied to numeric reference fields, where the field is referential and numeric.


The starting point of the segment. Previous characters are skipped.


The length of the segment to output.

For example, a Data Output Item has a Segment setting of Offset = 2 and Length = 3. If the Data Output Item value is ID235ZA, then the string 235 is output. The segment starts at the third character and is three characters long.