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

sum from selected field on another table

sirtemplar
in Calculation Engine (Define Fields)

Featured Replies

hi. i do not know if my subject is correct, however this is what i am trying to do.

i have a database with two tables. table 1 contains:

field1 (text)

field2 (number)

on field two there are values of 1500. what i want to do is put the some all the values with 1500 and put it on a field on table 2. how fo i do this?

Hi

1) make a global number field in table2

2) make a relationship ;)

Table1::field2 = Table2::gNumberField

3) make a calc field in table2:

Sum ( Table1::field2 )

From now, if you enter some number ( for example 1500 ) into gNumberField, the calc field will give you the sum of all related field2

Create an account or sign in to comment

https://fmforums.com/topic/51583-sum-from-selected-field-on-another-table/
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.