Jump to content

Find based on calculation


This topic is 3572 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

 

 

 

 

 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 3572 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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