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.

Find based on calculation

DFehrenbach
in Finding & Searching

Featured Replies

I am feeling sooooo stupid!

I am trying to do a Find on a Job table using a calculation field:

 

cCountProductionDays    which is defined as:  Sum ( JobToProduction::cProductionDay? ) (which is a boolean field in the Production table signifying whether or not the Production record is complete)

Extremely simple and straight forward. Displays correctly on Job table layout.

 

When I do a Find operation from Job table using 0, or >0, or =1, or <10, or .... anything - I get "No records match this find criteria"

 

I am CERTAINLY not new to FM, but at the moment I'm completely Brain Locked!

 

 

 

 

 

Are you doing a search on the calculation field that uses the SUM function or are you doing the search on the boolean field?

Are one or both fields setup to be calculation[number] fields and not something else?

Create an account or sign in to comment

https://fmforums.com/topic/92233-find-based-on-calculation/
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.