Home » SAP Analytics Cloud » ABS Function in SAP analytics Cloud

ABS Function in SAP analytics Cloud

Overview: In this tutorial you will learn how you can use the ABS function in SAP analytics cloud and how to find out the absolute number for negative numbers

ABS() Function:

ABS function in SAP analytics cloud return the absolute value for number without it sign. It is important sometime to show the number without sign, it helps a lot when you are showing some numbers in graphs and you need line above the zero axis.

Example if you have cost in negative (-ve) and you want to show bar chart in SAP analytic cloud then the value will show inverted and below Zero axis.

Lets go with few examples:

ABS() function in to show Cost chart

Lets take example that you have cost measures in your dataset and it is in -ve values

you want to show graph in ?ve values then how you can do that

You can use ABS() function to fix that sign issue in your graph

ABS(Total cost)

The above formula will replace Total Cost -ve sign with no sign and your graph will show on above zero axis

So lets take example of simple Bar chart in SAC for -ve cost which will look like as shown below image.

All bar is inverted way by product. it is showing actual cost by product, which is not good for representation. but you can change this inverted bar using ABS function in SAP Analytics cloud.

bar chart showing negative cost by product

Once you will apply ABS() function on that then it will show the bar in -ve and above the zero axis,

bar chart showing negative cost into positive using ABS Function in SAP analytics Cloud