Mathematics

Perform simple mathematical calculations (using constants and/or values copied from other variables) and place the result into a new or existing variable.

  1. Enter the 2 values on which you want to perform the calculation and select the operation you wish to perform. The available operations are:

    • Addition

    • Subtraction

    • Multiplication

    • Division

    • Modulus (returns the remainder obtained when dividing the first value by the second)

  2. Enter the name of the variable into which you'd like to place the result

If one or both of the values entered is non-numeric, the wizard will return an empty result in the variable you have specified. (Note that numbers including currency symbols are treated as non-numeric.)

You can use the Check Type command to validate that variable values are numeric prior to using them in mathematical calculations.