richshone Posted December 5, 2000 Share Posted December 5, 2000 I am trying to figure out an IF calculation that will enter the amount of tax I need to charge in a certain territory. I was thinking that I could something like: IF Country (in thins case the US) = x then enter 0, and IF Country (Canada), and State = y,z (1 thru 9) then enter 7, and IF Country (Canada - maritimes), and State = y, z (10 thu 12) then enter 15 I am not sure how to script something like this in Filemaker, anyone out ther who can help me? Thanks... Link to comment Share on other sites More sharing options...
Chuck Posted December 5, 2000 Share Posted December 5, 2000 You don't need to script it. A calculation field should be sufficient. Check out the Case statement. Case( Link to comment Share on other sites More sharing options...
Kurt Knippel Posted December 6, 2000 Share Posted December 6, 2000 quote: Originally posted by Chuck: You don't need to script it. A calculation field should be sufficient. Check out the Case statement... Something that might be easier to maintain would be a small related file, from which you can simply lookup the information based on a Country-State relationship. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8565 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now