Overview: In this tutorial you will learn types of Mathematical functions in SAC and how to use SAP Analytics Cloud mathematical functions in different scenario.
What is Mathematical Functions in SAC?
Mathematical function in SAP analytics cloud is the function which is used to calculate mathematical calculation based on constant, measures members. SAP analytics cloud formulas are functions which is in-build, which have keywords and parameters within brackets, based on that parameters it performed the Mathematical calculation example, SUM, MAX and MIN.
Below mathematical functions will helpful to design and create different chart view and table views. like bullet chart, time series chart etc..
Below are the list of all Mathematical function in SAP analytics cloud as formulas and you can see the details with example once you will click on the functions in below table
Mathematical Functions:
SUM( ) – I will sum up the measures and can be dragged in a table and graphs. SUM keyword can be performed on null values as well see the examples.
ABS( ) – This function returns the absolute value of a number (number without its sign).
EXP( ) – Natural exponential function, its Return the value of raised to a power.
MAX(number1, number2, …) – Returns the largest values of numbers from the list of more then two or more numbers.
MIN(number1, number2, …) – Returns the smallest values of numbers from the list of more then two or more numbers.
MOD(number1, number2) – Returns the remainder of dividing a specified number by another number.
POWER(number, power) – This function returns the result of a number raised to a power.
SQRT( ) – This function returns the square root of a number.
GrandTotal( ) – This function returns the grand total of values in the result set. Filters are included in the calculation of the grand total.
%GrandTotal( ) – This function returns the percentage of the grand total that each value represents or you can say shares of each members of column with total.
LOG( ) – This function returns the natural logarithm.
Conclusion:
These are the Mathematical function which can be used to perform the calculation based on measures, it will really helpful when you are dealing with complex dataset. With the use of this functions you can create calculated measures in dataset and can be used anywhere in the graphs, tables, story and dashboards.