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
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.