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

Need number calculation on found set if field is "no"

Adam in Santa Monica
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hey everyone. Seeking help on the below.

I have an summary field of 'amount' field. Works fine.

Now my boss wants additional summary field that shows total of only the records in found set that have "NO" in a particular field (in this case - 'client paid').

I have no idea. I was thinking of having it first do a search on the found set, along with the NO, then put then summary amount in the field as a global, then do the regular search without the NO.

Any advice would be greatly appreciated. Thanks!!

-adam the new guy

Hi Adam,

Welcome back to the world of FM Development.

How about another amount field that only calcs if the client has paid, then sum that field? If (clientStatus= "paid", amount, 0).

Also, if you're just setting this up, consider a DatePaid field, rather than a "hard-coded" No in client paid field. Then calc would be:

AmountPaid = If ( not IsEmpty (Date_Paid); amount; 0)

  • Author
  • Newbies

THANK YOU!! Woohoo! It totally makes sense, and I remember that type of logic ... its coming back to me now...

The program is so much more robust than the early versions... I am sure I'll have more questions coming up.

Again - thanks!

-adam

Glad to help. I'm sure you'll receive lots of excellent help here.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

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.