You need to sign in to do that
Don't have an account?
Seanno
Auto-calculate sales tax on opportunity depending on city/state.
I want to be able to calculate by default, the sales tax for california depending on the city the Account is located in...in the Opportunites page. I have downloaded the cities and tax rates for california in a spreadsheet and want to incorporate in a formula for the default area in the sales tax field in Opportunities. Keep in mind the names of the cities in California may be the same as other cities in other states, so we need to identify California as well. Thanks.
See my reply here http://community.salesforce.com/t5/Formulas-Validation-Rules/Formula-Limit-on-quot-Formula-Editor-quot-in-quot-New-Field/m-p/191613/highlight/true
in your case you would have to filter the report on California