Im sure someone has done this before

[filemaker 8 user]

Im new to Filemaker and trying to make a calculation to calculate sales price of my database of books. I have attached my database of pricing for you to look though to see my logic.

What im trying to do is set my sales price for each item in the database to be a set amount above cost. There are two variables that I have to contend with, one is a merchant fee of 14% of the sales price. The other variable is a credit card fee of 4% of the sales price. I have each item cost but im not sure how to set up the calculation field to set the sales price so that I make my desired profit margin.

Im sure this is really basic but Im new to this, any help would be great!

example.fp7.zip

[comment]

I think the formula to calculate the price needs to be:

( cost + margin ) / ( 1 - fees )

[filemaker 8 user]

Thanks for the reply. That got it!