ABS

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

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: