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.

Financial script

Featured Replies

  • Newbies

I want to track my gold account. I need some calculations that will do the following. I am not an accountant.

I want to track my debit/credit and leverage.

The fields I am working with are,

Debit, Credit, Deposit, Leverage amount, Purchased, and Quantity, Credit balance due, Total Market Value. Excess Equity, Total Account Value, Annual Percentage Rate.

I am able to do the math on paper but not able to create the calculation in filemaker.

You did not state what it is that you are trying to calculate. Is there a specific formula? You stated that you want to "track my debit/credit and leverage", but those fields you also list as being in your table already.

Math calculations are very straight forward if you are using a set of fields on a single record as input. The hard part is if you are trying to track running sums, or cash balances over multiple records.

  • Author
  • Newbies

I am trying to express algebraic expressions in a calculation.

This is most likely a better idea of what it is I want to do. Is there some plugin I need to install.

Can I create it VIA "C" and some how import it over to FMP ?

I am able to do the math on paper but not able to create the calculation in filemaker.

If you can explain how a particular calculation is done "on paper", we can help you write it in Filemaker's syntax.

Create an account or sign in to comment

Important Information

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

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.