Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Number functions > Abs function |
|
|
| Abs function |
| Format |
Abs(number) |
| Parameter |
| number - any numeric expression or field containing a numeric expression |
| Data type returned |
| number, time |
| Description |
| Returns the absolute value (a positive number) of number. For example, if a negative number appears in a field, the Abs function removes the minus sign and changes it to a positive value. |
| Examples |
| Abs(-123) returns 123. |
| Abs(PriceDifference) returns the positive value of the number in the PriceDifference field. |
| Abs(TargetDate - ActualDate) returns a positive value for the number of days difference between the values in TargetDate and ActualDate. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Number functions > Abs function |
|
|
Next Page |
|