MIN Function in SAP analytics cloud

Overview: In this tutorial you will learn and understand what is MIN() function in SAP analytics cloud and how you can use with example

MIN() Function

MIN() function used to find out the minimum values among more then one values. It will always return the minimum number in the list. It is used in statistic calculation to identify lowest number and also with MIN() function can be used with another functions.

Lets take few examples to understand MIN() function in SAP analytics cloud

Example #1: Return largest number with constant values

In this example you will see how MIN() function return the lowest values from more then 2 values

MAX(12, 56, 11, 43, 56)

with above example it will return 11 number as it is the lowest numbers in the list

Example #2: Return largest number between two columns

Lets take example for Unit cost, suppose you have 2 unit cost in your data set by category and you want to get lowest unit cost in your table view,

then you can use MIN() function as shown below formula

MIN( Unit Cost1, Unit Cost 2)

and it will return the lowest value in your third column in table view as shown below

table view explain the output of MIN function in SAP analytics cloud

This is the example from Table view but you can also use it for graph view as well (like combined chart and time series chart) and this will be more helpful when you are doing calculation for statistic analysis to calculate median and mean. So MIN() function will be helpful to do that.

Scroll to Top