Arithmetic Operators

FuseQL supports the following arithmetic 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.

abs

Calculates the absolute value of a numerical value.

Syntax

| abs(<number>) as <alias>

code

Example

The following example returns A with a value of 42.

| abs(-42) as A

ceil

Rounds up a numerical value to the nearest integer.

Syntax

| ceil(<number>) as <alias>

Example

The following example returns C with a value of 4.

| ceil(3.14) as C

cbrt

Calculates the cube root of a numerical value.

Syntax

| cubeRoot(<number>) as <alias>

Example

The following example returns R with a value of 3.

| cubeRoot(27) as R

exp

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

Syntax

| exp(<number>) as <alias>

Example

The following example returns E with a value of 2.71828.

| 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

The following example returns M with a value of 1.71828.

| expm1(1) as M

floor

Rounds down a numerical value to the nearest integer.

Syntax

| floor(<number>) as <alias>

Example

The following example returns F with a value of 3.

| floor(3.14) as F

log

Calculates the natural logarithm of a numerical value.

Syntax

| log(<number>) as <alias>

Example

The following example returns L with a value of 2.30258.

| log(10) as L

log10

Calculates the base 10 logarithm of a numerical value.

Syntax

| log10(<number>) as <alias>

Example

The following example returns L with a value of 1.

| log10(10) as L

round

Rounds the sample values of a numerical value.

Syntax

| round(<number>) as <alias>

Example

The following example returns R with a value of 4.

| round(3.5) as R

sqrt

Calculates the square root of a numerical value.

Syntax

| sqrt(<number>) as <alias>

Examples

The following example returns S with a value of 4.

| sqrt(16) as S