Salesforce Lightning Reporting and Dashboards

Using the MAX() function

The MAX function is categorized as the Math function; the syntax for this formula is MAX(number,number,...).

This function returns the greatest of all arguments, for example, MAX(Opportunity.Projected_Revenue__c:SUM, AMOUNT:SUM).

The same is true with the IF() function explained earlier; you can just point and click to get the preceding formula populated. In this sample, we use the opportunity report type, and the MAX() function returns the maximum value by comparing the sum of a custom field called PROJECTED REVENUE with the sum of AMOUNT. A sample report is shown as follows:

Let's analyze the preceding report;