Simple Calculation? Sales Tax

[MJG]

It seems like this should be a simple calculation, but I haven't worked with FM for a while and have never done too much with calculations.

What I need to do is define a Sales Tax field that says: If the Ship To State = MD, Sales Tax = Item Subtotal * .05.

I can't seem to figure that out using the options in FM though. I am using FM8.

Thanks for any help.

Mike

[Bicbel]

Hi, excuse me for my bad english language.

Try to use in a calculation field the function Case(testA, resultA, testB, resultB, ...)

Exemple:

Case (Ship to State=MD, Sales Taxes=Item Subtotal * 0,05, Ship to State=ND, Sales Taxes=Item Subtotal*0,10)

Saludos.

Edited October 18, 2006 by Guest

[MJG]

Thanks for the help. That is basically what I tried first. I have:

Case ( Ship State = MD ; MD Sales Tax = Item Total * .05{; Ship State ≠ MD; MD Sales Tax =0} )

However, when I try to save that as the definition for the field, it says that it can't find the MD field. Is there a way to say: if Ship State contains MD, then MD Sales Tax = Item Total * .05)? Not sure if using contains instead of = would make any difference.

Again, any help would be appreciated.

Mike

[BobWeaver]

You need to put quotes around MD. Then you get:

Case ( Ship State = "MD" ; Item Total * .05;0)

[bruceR]

You should probably be using a lookup instead of a calculation. Create a state table with fields for state and tax.

[MJG]

Bob,

Thanks. That did the trick.

Mike