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.

count values greater than zero...

Featured Replies

ok...this has to be an easy thing...but for some reason, i just can't get it. i have a field called 'money'. i need to count anything in that field and have it give me a number, but i only want it to count things in that field that are greater than zero....how do i do this?

Not really clear on the question or concept but something along the lines of If Money > 0... maybe?

  • Author

right....if money > 0...then count that as one. and then for every other field in that column that has a greater value then zero....count those as one too. that's where i'm having the problem. i can count them...and there's 24 in total. but i'm needing it to only count the values greater than zero.

  • Author

nevermind. i figured it out....

made another field called "count equation" that is a calculation of: If ( money > 0 ; + 1 ), then created another field called count, that just does a count summary of that calculation. it works. thanks for your help anyway!

Create an account or sign in to comment

Important Information

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

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.