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.

Summing Fields

Niet32
in Calculation Engine (Define Fields)

Featured Replies

I have a database that sums spending by brand.

The database holds spending for an entire year and I want the user to be able to choose a date range to pull desired spending.

I want to bring that sum into another database (I want to use a field to bring it in).

I am having trouble getting that number into the desired database.

I only want the sum of those records that are in the found set not the sum for the total records.

When I use a calc field referencing the SUM field it brings in the total spend not the spend for the found set.

Any thoughts on how to make this work?

Thanks for any help...

Create an account or sign in to comment

https://fmforums.com/topic/46257-summing-fields/
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.