function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
PetyaPetya 

Custom summary formula in Report

Hi

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) 
Navatar_DbSupNavatar_DbSup

Hi,

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.