Mathematical Functions
You use mathematical functions to perform mathematical operations. Many of the mathematical functions supported in the Calculation file, which is described in Calculation File, are also supported in report formulas.
The following table describes the predefined mathematical functions that you can use in report formulas.
|
Function
|
Function Description
|
|---|---|
|
abs(a)
|
Returns the absolute value of a
|
|
ceil(a)
|
Returns the smallest integer >= a
|
|
exp(a)
|
Returns the exponential
|
|
fac(a)
|
Returns the factorial of a
|
|
floor(a)
|
Returns the largest integer <= a
|
|
inv(a)
|
Returns the inverse (1/a) of a
|
|
ln(a)
|
Returns the natural logarithm of a
|
|
log(a)
|
Returns the Base 10 logarithm of a
|
|
mod(a,b)
|
Returns a modulo b
|
|
pow(a, b)
|
Returns a raised to the power of b (ab)
|
|
pow10(a)
|
Returns 10 raised to the power of a
|
|
root(a,b)
|
Returns the a-th root of b (  ) |
|
sqrt(a)
|
Returns the square root of a (  ) |
|
square(a)
|
Returns a * a
|
|
today()
|
Returns today’s date in the number of days since 12/30/1899.
|
To use a mathematical function as a data field, you must use the Value Field(Field) function to first return the value of the field. For example, to take the inverse of Failure Rate, Predicted, you use:
inv(ValueField(Failure Rate, Predicted))