+ Start a Discussion

Custom summary formula in Report


I need to find the Maximum from all values in a Report column with custom summary formula... but I don’t know how to ignore the grand total in my column...

Any ideas?

Best Answer chosen by Admin (Salesforce Developers) 


You have to simply use the Largest Value from that field inside the Formula field by select the Grand Summary only inside the Displayed section of Formula field in report.  Now you will be able to see that max value of that field in report. You can also achieve this without creating the formula field. You can select the Summarize this field option on that field and select max and save the setting.


Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.