# (d) Number Formulas¶

These formulas operate on text and text-like types. They are based on PostgreSQL mathematical functions and operators and comparison operators.

## Absolute Value¶

Returns the absolute value of the provided number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Editable?: No
• PostgreSQL Mapping: `abs()` function or `@` operator

• Date Type: Number
• Variables Accepted:
• Number 1:
• Type: Single Record Number-Like
• Description: First number
• Number 2:
• Type: Single Record Number-Like
• Description: Second number
• Editable?: No
• PostgreSQL Mapping: `+` operator

## Ceiling¶

Returns the ceiling (nearest integer greater than or equal to) of the provided number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Editable?: No
• PostgreSQL Mapping: `ceil` or `ceiling` function.

## Comparison¶

Compares two numbers and returns the result

• Date Type: Boolean
• Variables Accepted:
• Number 1:
• Type: Single Record Number-Like
• Description: First number
• Number 2:
• Type: Single Record Number-Like
• Description: Second number
• Comparison:
• Type: Choice (choices: `>`, `>=`, `=` `!=`, `<=`, `<`)
• Description: Comparison to use
• Editable?: No
• PostgreSQL Mapping: `>`, `>=`, `=` `!=`, `<=`, `<` operators

## Cube Root¶

Returns the cube root of the provided number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Editable?: No
• PostgreSQL Mapping: `cbrt()` function or `||/` operator

## Divide¶

Divides a number by another number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Number to divide
• Number to Divide By:
• Type: Single Record Number-Like
• Description: Number to divide by
• Editable?: No
• PostgreSQL Mapping: `/` operator. Note that we should convert integers to decimals before dividing.

## Factorial¶

Returns the factorial of the provided number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Editable?: No
• PostgreSQL Mapping: `!` or `!!` operator

## Floor¶

Returns the floor (nearest integer less than or equal to) of the provided number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Editable?: No
• PostgreSQL Mapping: `floor` function.

## Logarithm¶

Calculate the logarithm of a number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Base:
• Type: Single Record Number-Like
• Description: Base to use for the logarithm
• Default Value: 10
• Editable?: No
• PostgreSQL Mapping: `log` function

## Logarithm (Natural)¶

Calculate the natural logarithm of a number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Editable?: No
• PostgreSQL Mapping: `ln` function

## Modulo¶

Divides a number by another number and returns the remainder

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Number to divide
• Number to Divide By:
• Type: Single Record Number-Like
• Description: Number to divide by
• Editable?: No
• PostgreSQL Mapping: `%` operator or `mod` function.

## Multiply¶

Multiplies two numbers together.

• Date Type: Number
• Variables Accepted:
• Number 1:
• Type: Single Record Number-Like
• Description: First number
• Number 2:
• Type: Single Record Number-Like
• Description: Second number
• Editable?: No
• PostgreSQL Mapping: `*` operator

## Power¶

Calculate the exponent of a number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Power:
• Type: Single Record Number-Like
• Description: Power to raise the input number to
• Editable?: No
• PostgreSQL Mapping: `power` function or `^` operator

## Round¶

Round to a given decimal place.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Decimal Place:
• Type: Integer
• Description: Decimal places to round to
• Default Value: 0
• Editable?: No
• PostgreSQL Mapping: `round` function

## Square Root¶

Returns the square root of the provided number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Editable?: No
• PostgreSQL Mapping: `sqrt()` function or `|/` operator

## Subtract¶

Subtracts a number from another number.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Number to subtract from
• Number to Subtract:
• Type: Single Record Number-Like
• Description: Number to subtract
• Editable?: No
• PostgreSQL Mapping: `-` operator

## Truncate¶

Truncate to a given decimal place.

• Date Type: Number
• Variables Accepted:
• Number:
• Type: Single Record Number-Like
• Description: Input number
• Decimal Place:
• Type: Integer
• Description: Decimal places to truncate to
• Default Value: 0
• Editable?: No
• PostgreSQL Mapping: `trunc` function