Sorry, I should have added I'm running Windows 7 Pro and Filemaker Pro Advanced Version 10.
Cost / ( 1 - Margin )
Thanks for the quick reply.
Sorry, but I'll need someone to take me through this step by step please.
GrossMarginPercentage Number Click "Options" to create a value list ie.. 15, 20, 25... all separated by
SellingPrice Calculation ProductCost / (1-GrossMarginPercentage)
GrossMargin Calculation SellingPrice - ProductCost
Then in Layout mode double click on the GrossMarginPercentage field and select drop down menu and display values from your value list. Then format that field as a percent by going to the Format Menu > Number > Format as decimal > Use Notation Percentage.
You might also do some formatting to limit the decimal values on the selling price.
That all seems fine, except that if you enter "15" into a percentage field, it will display as "1500%" - and calculate accordingly (quite correctly, since 15% is actually 0.15).
Ooooops yea.... I originally had divide by 100 in there. Then formatting with a trailing % symbol changed everything. Make those numbers in the value list .15, .20, .25.
Thanks very much for your help folks, that worked perfectly.