Multiply
Syntax
Field field1
Multiply
Field field2
Multiply
...
Field destination_field
Parameters
- Multiply: Used between
Fieldcommands to mark fields that should be multiplied together. The finalFieldis 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