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