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.

summarizing a summary field

Featured Replies

I am tracking the number of items per month

I have a year and month field in the table.

I have a report that has leading and trailing subsummary for year and month.

on the leading subsummary by month, I can correctly total the items using "countofmonth" summary field.

on the trailing subsummary by year, I can also total the items for the year by using a calculation getsummary(countofmonth, year)

What I really want is a to display the average number of items per month. At a minimum, just the simple grand "average per month", but this on a yearly basis would be cool too.

What I cannot do is perform this calcuation:

If the yearly total for an item is 60, I cannot come up with a way to divide it by the number months (which would of course be 12)

any suggestions would be appreciated

Edited by Guest
Added Type

  • Author

After looking at this, I think I made it too hard to understand.

I reposted under this heading:

[color:black]

average of a "count" field

Sorry for the mixup

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.