Skip to main content
Topics#Data ManagementRoger Bannister 的问题
Roger Bannister 提问于 #Data Management
2015年6月8日 13:16

How can I calculate sales tax amount?

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 个回答
  1. Sunil Sarilla (M&G Investments)
    2015年6月8日 13:39
    +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