Overview: In this tutorial you will learn and understand what is MAX function in SAP analytics cloud and how you can use with example
MAX() Function
MAX() function used to find out the maximum values among more then one values. It will always return the Maximum numbers in the list. It is used in statistic calculation to identify highest number and also with MAX() function can be used with another functions.
Lets take few examples to understand MAX() function in SAP analytics cloud
Example #1: Return largest number with constant values
In this example you will see how MAX() function return the maximum values from more then 2 values
MAX(19, 3, 45, 67,34)
with above example it will return 67 number as it is the largest numbers in the list.
You can also use any field from the database or column from database, it will return the maximum value from that particular column.
Example #2: MAX() function to return largest number between two columns
Lets take example for Unit cost, suppose you have 2 unit costs in your data set by city and you want to get larget unit cost in your tabel view,
then you can use MAX() function as shown below formula
MAX( Unit Cost1, Unit Cost 2)
and it will return the largest 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 (like combined chart and time series chart) as well and this will be more helpful when you are doing calculation for statistic analysis to calculate median and mean. So max function will helpful to do that.