Version

## Math Calculated Fields

All functions in the MATH category will be useful for you to perform calculations on the fly. Certain functions, like the RAND and the RANDBETWEEN functions, are particularly useful to randomize the order of the rows in your data source.

The functions in this category are:

Function Name Function Syntax and Sample

ABS: `ABS` returns the absolute value (the number without the sign) for a number you enter.

Syntax: `ABS(number)`

Sample: `ABS(-3)`

EXP: `EXP` returns e (Euler’s Number) raised to a value you enter.

Syntax: `EXP(number)`

Sample: `EXP(8)`

LOG: `LOG` returns the logarithm of a number to the base that you specify in the arguments. If no base is entered, ReportPlus assumes that the logarithm base is "10".

Syntax: `LOG(number,base)`

Sample: `LOG(10,4)`

LOG10: `LOG10` returns the logarithm of a number. However, the base is always set to 10.

Syntax: `LOG10(number)`

Sample: `LOG10(1500)`

MOD: `MOD` returns the remainder, or fractional part, of a division between two numbers.

Syntax: `MOD(number,divisor)`

Sample: `MOD(5,3)`

RAND: `RAND` returns Real numbers larger than 0 and smaller than 1. The function takes no arguments. While you do not need to configure any arguments, you can include mathematical operators to further modify for your random numbers.

Syntax: `RAND()`

Sample: `RAND()`

RANDBETWEEN: `RANDBETWEEN` returns integer numbers that fall in the range you specify in the function arguments. You can include mathematical operators to further modify for your random numbers.

Syntax: `RANDBETWEEN(bottom,top)`

Sample: `RANDBETWEEN(0,9878654)`

SIGN: `SIGN` determines and returns the sign of a number.

Syntax: `SIGN(number)`

Sample: `SIGN(-1564)`

SQRT: `SQRT` returns the square root of a specified number.

Syntax: `SQRT(number)`

Sample: `SQRT(427716)`

TRUNC: `TRUNC` returns the integer part of a number; that is, not the decimals.

Syntax: `TRUNC(number)`

Sample: `TRUNC(65787.24657)`