Mathematical functions perform certain mathematical operations and return the resulting value. The mathematical functions you can use are listed below. Click on the function name to jump to a discussion of that function.
Function |
Result |
Returns the absolute value of a number. |
|
Averages a group of fields that share a naming method and returns the result. |
|
Counts the number of fields with values, shares a naming method, and returns the result. |
|
Returns the integer portion of a number. |
|
Returns the remainder from modular arithmetic. |
|
Tests if a string contains a valid numeric value and returns one (1) if it does or zero (0) if it does not. |
|
Handles calculations such as those needed to figure annuities and interests rates. |
|
Totals all fields that share a naming method and returns the result. |
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.