Skip to main content
Topics#Salesforce DeveloperTony Thomas's Question
Tony Thomas (Georgia) asked in #Salesforce Developer
Mar 14, 2023, 4:20 PM

ISPICKVAL

I am having a problem trying to get this to work:

IF(Bottle_size__c = TRUE,

      CASE(ISPICKVAL(Bottle_size__c ,"Fifth 750' ML  25.4 oz"),"25.4","0"),

              ISPICKVAL(Bottle_size__c ,"Liter 1000 Ml  33.8oz"),"33.8","0"),

              ISPICKVAL(Bottle_size__c ,"Half Gal 175 ML  59.2oz"),"59.2","0")))

I am trying to have it when you select the item it populates the total oz in a seperate field. When I do one it works but when I add the other 2 items it does not ork and throws a syntax error. I get this error: Error: Syntax error. Extra ',' but when I remove the "," the error just moves to something else each time. The basic formula seems good,. What can be the problem.  Thank you in advance.
2 answers
  1. Tony Thomas (Georgia)
    Mar 15, 2023, 12:51 AM
    I solved using this solution: 

    CASE(Bottle_Size__c,

    "Fifth 750 ML 25.4 oz",'25.4',

    "Liter 1000 Ml 33.8oz", '33.8',

    "Half Gal 175 ML 59.2oz",'59.2',

    "6 Pack",'6',

    "12 Pack",'12',

    "24 Case",'24',

    '0')

    it works now and thank you for the above response.
Write an answer...
0/9000