Skip to main content
Topics#CollaborationKyla Koerber's Question
Kyla Koerber (RSVP Advertising) asked in #Collaboration
Dec 20, 2017, 10:28 PM

Attempting to use Case formula to assign a picklist value a numeric value

I am trying to assign picklist values a numeric value by using the case formula. This is needed for reporting purposes to tally up a total amount.

 

I found this question asked before in the success community and tried a couple different formulas 

 

The Case formula seemed to address this best and here is the formula I am attempting to use 

 

Attempting to use Case formula to assign a picklist value a numeric value

 

Here is my result

 

User-added image

 

Any input much appreciated!
5 answers
  1. Ahilesh Ragavan Radhakrishnan (Simplus)
    Dec 20, 2017, 10:37 PM
    Hello Kyla,

     

    Try this formula:

    CASE( Ad_Size__c , 
    "Full Page",1.0, 
    "Half Page",0.5, 
    "Double Page",2.0, 
    0 
    )

    If the above formula doesn't work , replace the picklist values with their API names in the formula and try again.

     

    Hello Kyla, Try this formula:CASE( Ad_Size__c ,

     

     
Write an answer...
0/9000