Ok, so I'm pretty new to FM, so bare with me. What I'm trying to do is set up a text field that checks to see if the text in field ShipTo_State = TX, if it does then I want it to auto fill another field that would have "8.25%", however if it doesn't have TX then I'd want it to say 0%.

I'm trying to use:

If(ShipTo_State = "TX"; Taxed = "8.25%")

With "Taxed" field as my output text field, but if I put in TX in the state field, I get 0% in the "Taxed" Field, but if I put in any other state, it leaves the "Taxed" field blank.

Any help would be appreciated!

If you need more info, I'd be happy to explain further!

Thanks,

Andrew

If(ShipTo_State = "TX"; Taxed = "8.25%")

The correct syntax is:

If ( ShipTo_State = "TX" ; "8.25%" ; "0%" )

Tax rates change. It would be better to keep the rate in a field somewhere as data, instead of hard-coding it into a calculation formula.

See also:

http://fmforums.com/forum/topic/74315-bear-vs-bare/

Well as I stated, I'm pretty much completely new to FM, so I'm not sure how to do that lol.. I do understand that if tax rates do change and I have to manually change it in the calculation that It's going to change all previous invoices as well? Is it simple to add it like you said?

Try it this way?

LookupTaxRate.zip