Running Totals in a Portal
Reader Deborah wites:
Sure thing, Deborah! First, let’s tackle the portal row numbers. If all you’re trying to do is display row numbers, use the record number symbol, @@. In Layout mode, you can use the Insert > Record Number Symbol menu command, or you can just type it using the text tool. Place that bit of text in the portal, and you’ll see your running count of records.
As for a running total, you’ll need to define a summary field in the same table as your number field. When you create the summary field, choose Total of for for your summarizing option and choose the appropriate number field. Then, below the list of available fields, select the Running total option. Place your new summary field in the portal, and voilà!
Log in as a member to comment...
Most Recent Entries
- RSS Feed
- A little bit of SQL in FileMaker 12
- Upgrade to FileMaker 12 without Worries
- The Royal Treatment
- Select Script Options by First Performing Them Manually
- Understanding Line Indentation in Text Fields
- Using Custom Extended Privileges
- Searching Across Relationships for “Empty” Fields
- Making an Old FileMaker System Young Again
- Siri Rocks!!!
- FileMaker Developers Wanted: The Support Group is Hiring
- Using the Web Viewer as a “Field” in FileMaker Go
- Displaying iPad Video on Your Desktop
Seoirse Mac an Garda
12/06/2010
Good and clear explanation.