ABS- FineBI Help Document

Last update：December 13, 2024

Overview

Syntax	ABS(Number)	Returns the absolute value of the specified number. The value is always non-negative.
Parameter	Number	Any real number whose absolute value needs to be obtained.

Notes

The function supports only one numerical parameter and will be illegal if more than one numerical parameters are set.

Example

Sample data: Stock Trading Data.xlsx

1. For example, when calculating the difference between the quantities of purchased shares and sold shares using sample data, you need to obtain the absolute value of the difference.

Click Formula Column, set Name of the Added Formula Column to Absolute Value, enter ABS(Difference), and click OK, as shown in the following figure.

Add the Absolute Value field, as shown in the following figure.

2. The following table shoes more examples.

Formula	Result	Note
ABS(-1.5)	1.5
ABS(0)	0
ABS(2.5)	2.5

Previous：MAX - Returning the Maximum Value

Next：TRUNC - Returning a Number with Specified Decimal Places

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

ABS

Overview

Notes

Example

附件列表