Skip to main content

Multiply

Syntax​

Field field1
Multiply
Field field2
Multiply
...
Field destination_field

Parameters​

  • Multiply: Used between Field commands to mark fields that should be multiplied together. The final Field is the destination that receives the product.

Description​

Multiplies the contents of specified numeric fields and places the result in a destination field. Works similarly to Sum but performs multiplication instead of addition.

For scaling a single value by a constant factor, see Multiply By (a separate command).

Remarks​

Use Precision to control the number of decimal places in the result. Blank fields are treated as zero, which will cause the entire product to be zero.

Examples​

To multiply QUANTITY by PRICE and store the result in TOTAL:

Field QUANTITY
Multiply
Field PRICE
Multiply
Field TOTAL