I am trying to do this as per Knowledgebase Article
To count the number of records with certain picklist values, a formula field on the object is needed to count this. Then, this formula field is used in a report summary formula to calculate the % of the total records.
Scenario:
A field called 'Stage' has three picklist values called 'new', 'waiting', 'closed'. We just want the values of 'new' and 'waiting' but not 'closed'. Then I want to aggregate 'new' and 'waiting' and calculate the % of the report total.
1. Create two formula fields on the object using this:
Formula #1: IF(ISPICKVAL( Stage__c , "New" ), 1 , 0)
Formula #2: IF(ISPICKVAL( Stage__c , "Waiting" ), 1 , 0)
the value between the " " is the stage value. If true, then a 1. If false, then a 0.
2. Create a third formula field that adds both of the new formula fields above.
3. Go to the report, and then create a custom summary formula (CSF) that divides the report totals by the new formula.
but when I enter the formula in the new formula box I get this error
Field is a multi-select pick list field. Multi-select picklist fields are only supported in certain functions
What have I done wrong ?
