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.
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.
