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 problem w/calculated field including relation

Edward Newman
in Finding & Searching

Featured Replies

Ok, someone tell me I am not losing my mind! I have a solution, developed in 4, migrated to 5 and now 7. One of my reports is now not working and I am trying to fix it. The report has a find critera that searchs for "Balance" > 0. "Balance" is a calculated field set to ( "Sell Price" - "Invoice Total" ). Both "Sell Price" and "Invoice Total" are related fields. In browse mode, when "Sell Price" and "Invoice Total" are the same, "Balance" shows as 0. This is good. The problem is when I do a search, either manual or from a script of "Balance" > 0. It returns tons of records where "Balance" shows as 0. To make it worse, when I search on "Balance" = 0, I get some of the records that are zero and some that are not! Is this a problem with searching on calulated field with related fields in their calculations? Please tell me I am not crazy. This worked fine in v5

Hi, Edward. First step, check that Balance is a number field and not a text field.

HTH,

Jerry

Create an account or sign in to comment

https://fmforums.com/topic/29750-find-problem-wcalculated-field-including-relation/
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.