Skip to main content
Topics#Data ManagementDomanda di Cheshire Admin Admin
Cheshire Admin Admin ha fatto una domanda in #Data Management
13 ago 2015, 11:56

I have a pick list that contains percentages as the picklist values. I would like to use a formula in a report based off these pick list values however I cant because the system does not read the pick list as a percent.

How do I write a formula for if picklist = 25%, return the percent value for 25% if picklist = 50%, return the percent value for 50%, if picklist =75%, return 75%

 

I would like to use this formula return of the actualy % in a custom report formula
2 risposte
  1. Sunil Sarilla (M&G Investments)
    13 ago 2015, 12:04
    Hi Cheshire,

     

    Picklist and text fields are not supported in custom summary formula fields on the report, you need to create a formula field on the object and use that field in the custom summary formulas. your formula will be something like below

    CASE(Picklist_Field__c,
    "25%", 0.25,
    "50%", 0.5,
    "75%", 0.75,
    "100%",1,
    NULL)
    please sue the insert field button to select the API name of your picklist field.

     

     
Scrivi una risposta...
0/9000