Skip to main content
How can I calculate sales tax amount where currently the sales tax rate is a pick list field with 4 different percentage amounts?

 

I'm assuming some sort of formula but how would you do it with the picklist?

 

Any help or even hints would be appreciated.

 

Roger
4 answers
  1. Jun 8, 2015, 1:39 PM
    +1 Geoffrey,

     

    You could also use a CASE Function

    CASE(SalesTaxRate_Picklist Field__c,

    "10%",0.1,

    "20%", 0.2,

    "30%", 0.3,

    0

    )

     

     
0/9000