Share via


Math Functions (Report Builder 1.0)

Use Math functions to manipulate the numeric values of your data. For example, suppose you want to determine the grade point average (GPA) of the students attending a university. GPAs are typically reported as a numeric value between 1 and 4 and are calculated out to two decimal places. Using the ROUND function, you can calculate the GPA and then, if the value extends past two decimal places, you can round the number up or down accordingly.

Math functions can use the following data types: Decimal, Float, and Integer.

In This Section

Topic

Description

MOD (Report Builder 1.0)

Returns the remainder after a number is divided by a divisor.

ROUND (Report Builder 1.0)

Rounds a number to a specified number of digits from the decimal point.

TRUNC (Report Builder 1.0)

Truncates a number by the number of digits specified.