The “Divide” 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 “Divide” expression, which is performed using the / operator.

Mathematical Operators Overview #

Before exploring the “Divide” expression in detail, it’s helpful 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 “Divide” Expression Using the / Operator #

In the Assette Data Object Editor, division is performed using the / operator. This operator allows you to divide one numerical value by another to calculate a quotient.

Syntax #

value1, value2, value3: Numeric values or variables you wish to divide in sequence.

value1 / value2 / value3 / ...

How It Works #

Left-to-Right Evaluation: Division is performed from left to right.
Order Matters: Unlike multiplication, division is not associative, so the order in which you perform the divisions affects the result.

Examples #

Simple Division #

Divide one number by another. Result: 10

50 / 5

Using Variables #

If you have variables representing data points, you can divide them directly:
plaintext. Result: Calculates the average revenue per unit.

totalRevenue / numberOfUnits

Combining with Other Operators #

You can combine division with other mathematical operations. Result: Calculates the average cost per item after applying a discount.

(totalCost - discount) / numberOfItems

Important Considerations #

• Order of Operations: The Data Object Editor follows standard mathematical order of operations. Operations inside parentheses are evaluated first, followed by multiplication and division, then addition and subtraction.
• Division by Zero: Dividing by zero is undefined and may result in an error or an undefined value.
  plaintext
• Data Types: Ensure that the values you are dividing are numerical. Dividing non-numeric data may result in errors.

Using Division in Expressions #

Users can use the division operator in various expressions to perform calculations relevant to your data.

Simple Average
Calculate the average of a set of numbers. Sums the values and divides by the count to get the average.

(value1 + value2 + value3) / 3

Weighted Average

Calculate a weighted average:

(value1 * weight1 + value2 * weight2 + value3 * weight3) / (weight1 + weight2 + weight3)

Converting Units
Convert units by dividing with a conversion factor:

totalMeters / 1000