Arithmetic functions

Arithmetic functions are used to perform basic calculations on values in Profile Query Language (PQL). More information about other PQL functions can be found in the Profile Query Language overview.

Add

The + (addition) function is used to find the sum of two argument expressions as a number.

Format

{NUMBER} + {NUMBER}

Example

The following PQL query sums the price of two different products.

product1.price + product2.price

Multiply

The * (multiplication) function is used to find the product of two argument expressions as a number.

Format

{NUMBER} * {NUMBER}

Example

The following PQL query finds the product of the inventory and the price of a product to find the gross value of the product.

product.inventory * product.price

Subtract

The - (subtraction) function is used to find the difference of two argument expressions as a number.

Format

{NUMBER} - {NUMBER}

Example

The following PQL query finds the difference in price between two different products.

product1.price - product2.price

Divide

The / (division) function is used to find the quotient of two argument expressions as a number.

Format

{NUMBER} / {NUMBER}

Example

The following PQL query finds the quotient between the total products sold and total money earned to see the average cost per item.

totalProduct.price / totalProduct.sold

Remainder

The % (modulo/remainder) function is used to find the remainder after dividing the two argument expressions as a number.

Format

{NUMBER} % {NUMBER}

Example

The following PQL query checks if the person’s age is divisible by five.

person.age % 5 = 0

Next steps

Now that you have learned about arithmetic functions, you can use them within your PQL queries. For more information about other PQL functions, please read the Profile Query Language overview.