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

Summarizing Fields

tommypmadison
in Calculation Engine (Define Fields)

Featured Replies

Hello,

I have a database that tracks advertisment hits by a unique source code per ad...my problem is I can't fiqure out how to summarize and list how many hits per source code....does anyone have any suggestions??

Thank you,

T

Edited by Guest

1. Make a Summary field that is a Count of your unique code.

2. Make a new layout that's a list and follow the "wizard" steps to group the data.

What you end up with is a report with a Subsummary part that summarizes by your unique code, with your summary field below. Does that make sense?

  • Author

Tom,

I think I didn't describe my situation properly, my database has approximately 30 different ad codes with about 12,000 hits, and my desire is to have a list of how many times each ad code is hit.

Thanks again,

Tom

The sub-summary report that Fitch described should solve it. Put it in a layout based on the Hits table.

  • Author

Thanks,

That worked!!! Thanks again!

Tom

Create an account or sign in to comment

https://fmforums.com/topic/49087-summarizing-fields/
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.