ABS- FineBI Document

Last update： 2022-04-15

1. Overview

Grammar	ABS(number)	Return the absolute value of the specified number, which is always non-negative.
Parameter	number	Any real number that needs to find the absolute value.

2. Precautions

A numeric parameter is supported. If it exceeds, it is illegal.

3. Example

Sample data: index trading data.xlsx

For example, after using the sample data to calculate the buy-sell difference, you need to get the absolute value of the difference. Use the "New column" in the self-service dataset, name it then enter the formula ABS(Difference) and click "OK", as shown in the following figure:

Note: the functions and fields in the formula box need to be selected by clicking the selection area on the left, and cannot be entered manually.

At this time, the processed absolute value data appears in the self-service data set, as shown in the following figure:

More examples are as follows:

Formula	Results	Notes
ABS(-1.5)	1.5
ABS(0)	0
ABS(2.5)	2.5

Helpful
Not helpful
Only read

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

English

ABS

1. Overview

2. Precautions

3. Example

附件列表