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 |
|---|---|
Returns the remainder after a number is divided by a divisor. |
|
Rounds a number to a specified number of digits from the decimal point. |
|
Truncates a number by the number of digits specified. |