Jump to content

Search the Community

Showing results for tags 'summary'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting


  • Community Calendar
  • FileMaker User Groups

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. Hello, everyone, here’s my latest question. I hope this is the proper area to post it. I’m creating a flat-file movie database to keep track of where my movies are in my home. I added a serial number field, which gives me a running total of how many movies are in my collection. But I think I need something different, and am requesting help for creating it. I have several duplicate movies in my collection, and I don’t want the duplicates included in any total count of my movies. At least, not in my forms or reports. I don’t care if duplicates get serial numbers, and I don’t care if th
  2. I have a layout that includes two sub-summaries. The topmost includes a summary field called studentGradeCount, which counts the number of students in a given grade. The subordinate sub-summary contains applicationStatusCount, which is a summary field providing a count of applicationStatus. Adjacent to the status count, I would like to provide a percentage, indicating what percent of the students have applications at each status. Logically, it would be applicationStatusCount / studentGradeCount But FileMaker doesn't return anything when I attempt this. Any help would be app
  3. I'm running into an issue hiding a text object in a sub summary part when a summary field in the same part is empty or zero. I created a little demo file to show my issue. I resorted to using Get Summary, but that still doesn't work in my solution (but it's much more complicated report there). I'd appreciate feedback as to why I needed Get Summary. tia, Barbara summaryhide.fmp12
  4. Hi, I made a Filemaker Database a couple of years ago for a correspondence school, now I'm building the same thing for another school. The database has a record for each student and a field for each possible lesson they can be sent. When a lesson is sent the date goes in the appropriate field. For reporting I had no idea what I was doing, so I just made a table with a field for each lesson and a script that would search within a date range, take a record count of the returned records take that number and put it in my report table. The date range is set by global fields
  5. Hey Guys, Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue) My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
  6. I'd thought I'd solved this but looking at the background data it's not calculating properly. Any ideas much appreciated. I have a file with a date, bottle format, total cost and converted cost for larger formats (so, for example, 75cl might cost $20 but 1.5l costs $45. The converted cost of the 1.5l is $22.5). Assuming one beverage and just one bottle of each, I want to output a report which looks at the costs and converted costs over a specified period (eg 1/1/2016...12/31/2016) and outputs a 'premium' for, say, the 1.5l bottle. In this example, let's say I have 6 records: date1
  7. Hi, I'm having some difficulties with my invoice-system. When having multiple pages on print, I want to have my Trailing Grand Summary on a fixed spot. (not trailing) Is there a possibility to have this result? If I would place my fields in the footer, they will show on every page, what is not the intention. Have you fixed this one before OR do you have a solution at hand? Thanks in advance!
  8. Hi can anyone point me in the right direction, I have a database that as a Field populated by a value list, i.e.,: Christmas,Easter,Mothers Day , etc. I want to chart how many records exist of each chosen category. I thought it would be from a summary field using Total of and count but that option isn't available, How do I get filemaker to count the number of uses of the word Christmas from that field , can anyone help please? Thanks in advance
  9. I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK. However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours. I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout? Please can someone provide assistance because I have another 20 similar reports t
  10. Can anyone explain how FM treats a summary field if weighted by date? For example, say I have one transaction each month over 5 years. I want an average of these that would be a total each month's transaction values divided by 60. What if this were weighted by date?
  11. People like using cats in this forum and it keeps it simple. Let's say I have 3 types of cat (C) - Moggy (M), White (W) and Siamese (S). I am recording prices and using these prices for a report which produces their average price. I want to work out the premium that one breed of cat has over another expressed as a percentage of, say Moggies. I have 3 prices for Moggies: $20,$21,$22; 3 prices for White cats $30,$31,$32 and 3 prices for Siamese - $50, $55, $60. My nice summary report produced from a script shows the average prices OK but how can I work out the premium for the other bre
  12. I have a need for a lot of cross tab calculations and have referred to the FM 13 Advanced Training Series, lesson 38 which covers this. I've used it for a while now but it's brutal in that you need to create two calculations for each individual 'cell' you wish to display: One calculation tells Filemaker what should be summarised, usually via a CASE statement. The other is the Summary field itself which appears on the layout. I tend to require 10, sometimes more columns which are based on date fields from an overall record list of 70000 so far. Is there not a better way of doing the cross
  13. Hi there I HOPE this is in the right place... I'm still trying to wrap my head around the FM SQL syntax and to a certain extent have had success. I'm preparing some chart information and need to show a margin percentage over a period of time. This would be calculated as (Income-Cost)/Income/*100. The ExecuteSQL statements at the end of the code should give me 5 percentages to compare over a period of time. My income and cost records are defined clearly in the data table each one having a text tag of either INC or COST, so DataTable::Amount records are either INC or COST. In turn, these
  14. Hi there I have a quick question regarding the final output of a summary zero result. I'm setting up a user import routine that needs to be very, very simple to use with checks and measures throughout. The data that's being imported, due to its nature, always comes back to a summary value of zero. This is the correct position. I'm currently at the testing phase where I'm summarising the values field to get a total and the result is always displayed as "-3.6e-11". Now, I'm happy that's zero, but I want to use this in a custom dialog box: "Your check digit is"&sCheckDigit Obviously I
  15. Hi, I have a simple correspondence database with three tables: Contacts (called PEO), Correspodence (called peo_peocoo_COO), and a joint table called peo_PEOCOO. In Contacts, one of the fields is Country. I need to give a single number of how many countries has received correspondence from my team, so I wanted to count number of countries (not the number of times each country has ocurred) in the joint table. I am however having difficulty at using the methods commonly posted in the forums and would really appreciate some assistance. As an example, I have China China Japan China US
  16. I've got a bunch of student records, which include nationality and a progression decision. I would like to see the progression rate by nationality.  I've attached a screenshot of what I'm currently getting on a layout with sub-summaries sorted by nationality.   The # of students and the # of students progressed seem to be working. These are both summary fields, with the progressed number being the total of a calculation that is 1 if they progress and 0 if they don't. For the %, I have a numeric calculation field where I divide the two summary fields: (s_countStudentsProgress
  17. Is there a fast way to calculate all the invoicebalance listed base on the found records? here is my current process Enter FindMode SetField ( invoice layout::Invoice Balance > 0 ) Perform Find Set Variable: Name: $currentBalance Value: Let ( [ ~list = ListValues ( invoice layout::Invoice Balance ) ; ~total = TotalList ( ~list ) ]; #AssignGlobal ( # ( "currentBalance" ; If ( IsEmpty ( ~total ) or ~total ≤ 0 ; 0 ; ~total ) ) ) ) But this process takes a while to finish if i have 10 record in the found records
  18. MS Access has 'group by' and it easily shows the number of records after grouped by particular field. e.g. [DATA ( 5 records ) ] Type Quantity 001 1 001 1 002 3 003 1 003 2 MS Access shows 3 (The number of records after grouped by 'Type') and result below in a second. 001 2 002 3 003 3 As far as I know, I have to make another table to have unique record(by 'Type) , and to count quantity. This is too much work compared to MS Access. In another way, I have to Make List view and add'sub-summary when sorted by' to it
  19. Hi all - thanks in advance for any help you can offer.  I'm currently working on a report to show average keyword ranking (in Google search results) for a group of keywords, reported at monthly intervals.  I have a table which stores the average ranking position of 4 keywords, "marzipan", "flower paste", "ready to roll icing" and "fondant icing" each month (stored in field "SR_Keyword_Position")  In this table I also have a summary field ("SR_Average") which calculates an AVERAGE summary of field "SR_Keyword_Position"  I have a list layout for this table with a sub-summar
  20. Hi all - I'm working on a reporting tool to display the number of facebook page likes a page has and track it over 3 months. I have a portal displaying the number of facebook page likes over a 3 month period (portal fixed at 3 rows) (portal row 1) 31-Dec-2013 Facebook Likes: 1806 (portal row 2) 31-Jan-2014 Facebook Likes: 1917 (portal row 3) 22-Feb-2014 Facebook Likes 2017 I need to calculate the increase / decrease between the first and third portal row eg: difference between 2017 and 1806 (211) Any ideas on how this can be achieved? I can o
  21. I am using FM 12.04 Advanced  I have a membership application.  Members -->> Dues  The LO is based on Dues     The problem is I can not get a Summary Count for Members::MemDuesStatus (Current or Late). I have placed the summary field in Dues. Didn't work. I placed the Summary field in Members. Didn't work.  The perplexing thing is that the Blue fonted Summary Totals work?  Is there something different about Count?  Â
  22. I'm using FMP 11 Advanced: I have a a report using a list layout in which a sub-summary part displays donations for each individual. Donations fall into different giving categories (High, Medium, Low -- for easy discussion). If there are 50 overall gifts for this year, I'd like to tally how many "High," how many "Medium," and how many "Low," gifts there are. I am setting a High, Medium or Low flag for each gift. If ( GIFT = "1-99" ; 1; "0" ) NOTE: I can NOT store or index this field because it references a summary field / unstored / calc field… Now I want to tally up those Flags
  23. Hi I'm currently working on a database where photo's are ordered on a website and need to be managed (via .csv imports) in FM12. This is all working pretty well so far but my problem is with the reporting/summary. The setup is that a FMdb (iPad/FMgo) generates the data that is imported into the site CMS where customers can order specific prints. That works fine. The modified data is exported (CSV) from the CMS and imported into another FMdb, that is related to the initial FMdb (where the data is generated). This second FMdb is the one that will generate invoices and ordertickets and s
  24. Hi There, I have a database with 1000's of children's games. I have teachers in other parts of the world classifying the games into categories. When they log in, a find is performed to bring up a specific 100 games for that teacher to categorise based on topic. The teacher categorising the Games to teach the animals (100 games) has a readout telling the teacher that s/he is on E.g. Game 4 out of 100 which is a calcualtion I made. Once they are done they check the 'Done' box in the Games::Done field. The teachers have requested that there is a readout telling them how many games
  25. Help! I have no idea how to go about getting this 'idea' (demand) in place. I've attached a picture of what I need, to help with my poor explanation skills. I have what is essentially a medical record. For each ID number, there is a lot of things being entered. I'm stuck on one section. "Actions". I need to be able to state what day an action (once a day, twice a day, etc) was 'started' and 'stopped'. There can be more than one action active at one time. Each with it's own start and stop date. I need to keep a history of these start/stops (but not visible on the current ta
  • Create New...

Important Information

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