Version
Diagram Step 3.png

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)