Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Im sure someone has done this before

filemaker 8 user
in Calculation Engine (Define Fields)

Featured Replies

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

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

( cost + margin ) / ( 1 - fees )

  • Author

Thanks for the reply. That got it!

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.