The “Multiply” Expression

The Assette Data Object Editor supports a variety of expressions and functions that allow you to manipulate and calculate data effectively. One of the fundamental mathematical operations available is the “Multiply” expression, which is performed using the * operator.

Mathematical Operators Overview #

Before diving into the “Multiply” expression, it’s beneficial to review the basic mathematical operators supported by the Data Object Editor:

• Addition (+): Adds two or more numbers together.
  • Example: 1 + 2 + 3 returns 6.
• Subtraction (-): Subtracts one number from another.
  • Example: 10 - 9 - 8 returns -7.
• Multiplication (*): Multiplies two or more numbers.
  • Example: 1 * 2 * 3 returns 6.
• Division (/): Divides one number by another.
  • Example: 1000 / 10 / 10 returns 10.

The “Multiply” Expression Using the * Operator #

In the Assette Data Object Editor, multiplication is performed using the * operator. This operator allows you to multiply numerical values together to calculate products.

• The “Multiply” expression in the Assette Data Object Editor is performed using the * operator.
• Use the * operator to multiply numerical values or variables.
• Combine multiplication with other mathematical operations for complex calculations.
• Use parentheses to control the order of operations and ensure accurate results.
• Be mindful of zero multiplication and handle null or undefined values appropriately.

Syntax #

value1, value2, value3: Numeric values or variables you wish to multiply together.

value1 * value2 * value3 * ...

How It Works #

• Left-to-Right Evaluation: Multiplication is performed from left to right.
• Associative Property: Multiplication is associative, so the grouping of operations does not affect the result.

Examples #

Multiplying Multiple Numbers

Multiply two numbers. Result: 100

5 * 10 *2

Multiplying Variables
Calculate the total revenue

unitPrice * quantitySold

Complex Calculations

Calculate compound interest. Use the Power(n1, n2) function to raise a number to a power.

principal * Power((1 + (interestRate / periodsPerYear)), (periodsPerYear * years))