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.

Way too difficult to subtract between two records?

Mabou
in Calculation Engine (Define Fields)

Featured Replies

Hi all,

I am dumfounded as to why it is so difficult to subtract the value of one field from the same field in a different record. I have posted this question in many FM forums and have gotten a wide variety of responses, all of them frightfully complicated. There must be a simple answer for this because it is NOT an unusual request.

I have a flat file (no relationships, portals, etc). There are only two records visible. I need to be able to subtract the values of record 2's fields from the same fields in record 1 and show the results in the third in the footer. There are about 15 fields that will be compared and the results for each will either be a negative number, 0, or a positive number.

Hi Mabou,

Do you have only two records in your database? Or do you have a search mechanism that will always find exactly two records?

Regards,

Ernst.

Create an account or sign in to comment

https://fmforums.com/topic/17270-way-too-difficult-to-subtract-between-two-records/
Go to topic listing

Important Information

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

I accept

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.