You need to sign in to do that
Don't have an account?
SueHall
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
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
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.