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
SueHallSueHall 

Need to assign numeric values to pick list values to be totaled

Does anyone have any suggestions?

In the opportunity I have created pick list fields and each pick list value as an associated numeric value.  The goal is to create a field that will total up the corresponding numeric values.

E.g.
Field: More Info Needed?
Field Values: Yes (5), No (0), Maybe (3)

Field: SLA In Place?
Field Values: SLA (5), STA (0), STT (3)

Thanks!
Sue
TCAdminTCAdmin
Sue,

You can do this within a formula using the CASE function.  It would be something like:

CASE(More_Info_Needed__c, "Yes", 5, "No", 0, 3) + CASE(SLA_In_Place__c, "SLA", 5, "STA", 0, 3)

You will need to you the merge fields for the fields and use a formula(number) field.