+ Start a Discussion
ChichoChicho 

update field with picklist values

I have a picklist list with the following values: YES, NO, MAYBE. I have another formula field that calculates the value of YES, NO, and MAYBE by assigning to each of them a particular score: YES = 10, NO = 0, MAYBE = BLANK.

When I add this field to a report the records with any of the three values shows the number of points, that is, 10 or 0 or BLANK, and calculates the average result based on the different scores.

I need to show on the reports only the records scoring YES or NO and remove MAYBE. Then the average would be calculated based on the total number of YES and NO instead of the total number of YES, NO, and MAYBE.

How can I do this? Thank you!!
Sonam_SFDCSonam_SFDC

Hi Chicho,

 

When creating the report - you can add a filter to the report and use the formula field in the filter to show only record with values as YES or NO 

 

This way you will have that set of records and you can summarize and get the result for YES and NO records:

 

Read more on how to do this:

 https://help.salesforce.com/HTViewHelpDoc?id=reports_builder_filtering.htm&language=en_US

https://help.salesforce.com/HTViewHelpDoc?id=reports_filter.htm&language=en_US

 

Hope I've understood your question correctly and the above info helps!