ABS
Returns the absolute value of a number.
Syntax
ABS(<number>)
Parameters
| Term | Definition |
|---|---|
| number | The number for which you want the absolute value. |
Return value
A decimal number.
Remarks
The absolute value of a number is a decimal number, whole or decimal, without its sign. You can use the ABS function to ensure that only non-negative numbers are returned from expressions when nested in functions that require a positive number.
Example
The following example returns the absolute value of the difference between the list price and the dealer price, which you might use in a new calculated column, DealerMarkup.
= ABS([DealerPrice]-[ListPrice])
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for