Arithmetic operators

FuseQL supports the following arithmetic functions:

Functions

• abs: Calculates the absolute value of a numerical value.
• ceil: Rounds up a numerical value to the nearest integer.
• cbrt: Calculates the cube root of a numerical value.
• exp: Calculates Euler’s number, e, raised to the power of a numerical value.
• expm1: Calculates exp(<number>) − 1 for a numerical value; compensates for round-off errors in exp.
• floor: Rounds down a numerical value to the nearest integer.
• log: Calculates the natural logarithm of a numerical value.
• log10: Calculates the base 10 logarithm of a numerical value.
• round: Rounds the sample values of a numerical value.
• sqrt: Calculates the square root of a numerical value.

Details of Functions

abs

Calculates the absolute value of a numerical value.
Syntax

| abs(<number>) as <alias>

Example

| abs(-42) as A

ceil

Rounds up a numerical value to the nearest integer.
Syntax

| ceil(<number>) as <alias>

Example

| ceil(3.14) as C

cbrt

Calculates the cube root of a numerical value.
Syntax

| cubeRoot(<number>) as <alias>

Example

| cubeRoot(27) as R

exp

Calculates Euler’s number, e, raised to the power of a numerical value.
Syntax

| exp(<number>) as <alias>

Example

| exp(1) as E

expm1

Calculates exp(<number>) − 1 for a numerical value; compensates for round-off errors in exp.
Syntax

| expm1(<number>) as <alias>

Example

| expm1(1) as M

floor

Rounds down a numerical value to the nearest integer.
Syntax

| floor(<number>) as <alias>

Example

| floor(3.14) as F

log

Calculates the natural logarithm of a numerical value.
Syntax

| log(<number>) as <alias>

Example

| log(10) as L

log10

Calculates the base 10 logarithm of a numerical value.
Syntax

| log10(<number>) as <alias>

Example

| log10(10) as L

round

Rounds the sample values of a numerical value.
Syntax

| round(<number>) as <alias>

Example

| round(3.5) as R

sqrt

Calculates the square root of a numerical value.
Syntax

| sqrt(<number>) as <alias>

Example

| sqrt(16) as S