Jump 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.

Featured Replies

Help me, I'm struggling with the process I want to achieve.
Here is the process for setting the amounts in my Plan B:

image.png.58d432074f38c46b8fe55eebb7dec662.png
I have a field for the Enrolment Fee with an amount of 715, which I will subtract from the Total School Fee of 21,605. The total difference of 20,890 will be divided by 8, resulting in 2,611.25. Let's assume this amount is 2,620. Now, this 2,620 needs to be set for the month of September. 
Like this:

image.png.c9485eaf6bf2e87e04af80790a4bd57e.png

The next step, to set the amount for the month of October, is to subtract the amount of September ( 2,620 ) from the Miscellaneous Fee that has an amount of 3,400. So the total difference is 780. So here's what i want to happen,  I want to set an amount of 2,610 for the months of October to May. Therefore, I need to subtract an amount from the Tuition Fee that has an amount of 16,440 and add it to the 780 to make it 2,610. 
Then repeat the process of subtracting the amount from the Tuition Fee until the amount of 2,610 is set for each month from October to May.

What calculation or script that I need to get this process perfectly? Thanks in advance.

  • 5 months later...

Hey Mark, we have no understanding of your relational structure which makes it impossible to offer solutions.  To start, I suggest you post a screenshot of your graph but far better is to post the file itself.  You can post a clone:  File > Save A Copy As > Empty Clone or create a new small demo file with only the tables & fields necessary to show your issue.

In FileMaker, perspective is everything (well, at least MOST things, LOL).  :thumbsup:

Create an account or sign in to comment

Important Information

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

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.