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.

average calc

RET
in Calculation Engine (Define Fields)

Featured Replies

I have 12 different sections in my database on each section it will total up. Some of these sections may not be filled out yet. I need to create a calculation base on the number of sections that contain totals. For example section 1 has the total

The only way that I can think of is to have another set of fields that simply set a flag (1 or 0) on a completed "section". You then have another field which counts those flags and use that as the divisor for your averages.

  • Author

RET

I am pretty much a beginner at calculations, so could someone please give me an example on how I would write a calculation like that.

Flag those fields that are not empty or have a "0" in them.

Please HELP!

RET

if ( not isempty ( TotalField1 ) ) will result in a 1 if there is something in the field, or a 0 if not.

Alternately you could test for a value: if ( TotalField1 >= 1 ) which will result in a 1 if the TotalField1 is greater than or equal to 1.

Create an account or sign in to comment

https://fmforums.com/topic/3140-average-calc/
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.