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