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.
Once you will apply ABS() function on that then it will show the bar in -ve and above the zero axis,