Math operations

Use a math operator to combine two or more input data fields into a single output value. The math operator is applied to each input value in the order that the value displays in the source (input) list.

Math operations result in integers. The division (DIV) and average (AVG) operators use real, floating point, numbers for their intermediate calculations. The final result is rounded up for fractional values of .5 and above, and rounded down for fractional values below .5.

When converting to HEX types, the correct decimal to hex is performed. Conversely, when converting from HEX types, the value is properly scanned as a hex number.