function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Terry_0101Terry_0101 

Average Age of a record with a certain picklist value

Need a formula that separates the picklist values of the Opp Type field.  Then show the average age of that opp (created date - closed won).

Need a separate formula rather than use the report's summary formula.
Terry_0101Terry_0101
I have:

IF
(ISPICKVAL( Type , 'High'),
(ISPICKVAL( Type , 'Medium'),
Age_Days__c ,0))