Jump to content

Search the Community

Showing results for tags 'summary'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker 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 Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 28 results

  1. 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 table/portal). Also, the less typing the people entering the data have to do, the better (drop down menus, etc). I also need a "summary" of what is currently active. This means some sort of script that says shows fields that have a start date, but no end date containing a date newer than the last start date... or something along those lines. I'm feeling overwhelmed. Please help!!! ~Kim~
  2. 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 tab calcs, something like (psuedocode) as I'm wary of fattening up the fields on the DB: Calc1::DoSummary (Case (DatePeriod = 1 and SortField = "Tourist" ; Amount))Rather than two calculations: Calc1 ::Case (DatePeriod = 1 and SortField = "Tourist" ; Amount)sCalc2L::Summary Calc1Thanks all
  3. balooka

    Grouping summary

    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 so on. The structure is: VENUE (keyA) -> GROUP (keyA) | (keyB) -> ARTIST (keyB) | (keyC) -> PHOTO (keyC) When I generate an orderticket I use summary sort like: -VENUE -- GROUP --- ARTIST--> PHOTOS Which is perfect! But... If an artist has multiple images and also orders multiple it will list all ordered items like above. So Artist1 order 5 images and I'll and up with 5 lines (--- ARTIST--> PHOTOS). That is fine for the orderticket but not for the invoice (unspecified for a reason). Is there a way to only show one instance of Artist1, where the costs are grouped. So even if Artist1 has ordered 10 photo's of 1 dollar each, it will not list 10 lines, but just one with a value of 10 dollar? If I make a selfjoin on the PHOTO-table I can see in the portal that the amounts are added nicely to one sub-summary, but in the report I have no clue on how to omit all the instances but one with the summarized (sp?) price... I hope this made sense, my English isn't all that Thanks a lot!
  4. 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 to do and this will take me days instead of hours
  5. 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, but they unstirred, so I'm not sure how to do that in the report / "on the fly." I made a self-join relationship which I had hoped would "find" all the records which have that flag (High, Medium, Low) and then I could create a field to tally the number of records in the category by using get(found count). It doesn't work. Any ideas? Thanks
  6. 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 are split into two other columns so I can summarise Income and Cost elsewhere in the system. I want to use these columns now to generate a percentage on a chart. I need to somehow get that into a SQL statement - the statement below doesn't work (I believe because I'm querying the derived fields of INC and COST which seems ridiculous that you cannot do this, so probably it must be me making an error). If I were to do Select SUM(Amount), this works fine as Amount is simply a number field? Thanks in advance for any help Let ([ CUST = Customer_Home::Cust_PK; SQL = "Select (SUM(INC)-SUM(COST))/Sum(INC) from DataTable where CustID_FK=? and GroupID = ? and PeriodNumber=?"]; ExecuteSQL(SQL;"";"";CUST;1;5) & "¶" & ExecuteSQL(SQL;"";"";CUST;1;4) & "¶" & ExecuteSQL(SQL;"";"";CUST;1;3) & "¶" & ExecuteSQL(SQL;"";"";CUST;1;2) & "¶" & ExecuteSQL(SQL;"";"";CUST;1;1) & "¶" )
  7. Another report question. I have a report that using a summary field to total a figure for each person. It turns out you can't sort by a summary field. So if you had a report that had, Bill recruited 10, John recruited 7, etc etc, and you wanted the report to list them in order by the total recruited, what would you do? The only thing I can think of is to somehow get the data out of the summary field in to a new field for each person, then sort based on that. thanks
  8. 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
  9. 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?
  10. 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
  11. 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 Japan UK UK The number I would expect from the above is 4 - Four countries have received our correspondence in the past. I've tried using the ExecuteSQL method by creating a calculation field ("SELECT COUNT (DISTINCT Country) FROM peo_PEOCOO" ; "" ; ""). I however ended up with a question mark in every record. I've tried the "sum the reciprocal" method, creating, in peo_PEOCOO, a summary field CountryCount (which resulted in total number of records), a caculation field FractionOfCountryCount (which shows number of times each country has ocurred), and another summary field FinalCountryCount (which resulted in the sum of number of times each country has ocurred). Still couldn't get the number of countries in the peo_PEOCOO table. Finally, I tried "self join" method, creating a second peo_PEOCOO_SelfJoin, creating a calculation field in peo_PEOCOO called Counter, which is Count(peo_PEOCOO_SelfJoin::Country), and a summary field called CounterTotal which is a Total of Counter. It ended up again with the sume of number of times each country has ocurred. I would grateful if the community can help point out what went wrong in all my methods. A great many thanks for your time and help. Cheers, The MacGuffin
  12. 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?  Â
  13. 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'd rather have "Your check digit is 0.00" displayed, rather than "Your check digit is -3.6e-11" I can't format it because it's not being used on a layout, I can't use GetSummay because there's nothing to break on given the flat nature of the import. Any help really appreciated on this, thanks
  14. 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
  15. 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 only seem to summarise totals / averages etc with summary fields.
  16. 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!
  17. 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 for the start date and the end date. The script would repeat for the 200 or so lessons that we had available. I would then have a report of the number of each lesson that was sent in a date range. I guessing that there must be a better way, I have never used a summary report, is that something that would work? If someone could point me in the right direction I would be very very grateful. Thanks heaps in advance for any help or pointers. Using Filemaker 16.
  18. 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_countStudentsProgressed / s_countStudents)  As you can see, the percentage I'm getting is that total overall progression rate, rather than the value in each sub-summary section. What am I missing? I can't use the "fraction of" summary field, because I don't want to know what percentage of our progressing students come from a certain country. I want to know what percentage of students in a certain country progress.  Any help would be greatly appreciated. And if you have any questions for me, please don't hesitate to ask.  Thanks! Dave
  19. 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.
  20. Hello all, I have a portal from a related table and it has multiple iterations on a particular layout with different filters to display different records of interest. I want to create a summary field that can summarize the DISPLAYED records (not all records from the portal's source table) for each portal shown. I realize it is possible to solve this dilemma by using a single portal and using a global search field to conditionally define a filter (and thereby make it possible to easily solve this issue too. But is there another way to do it that allows me to display ALL the portals at the same time with summary fields? I want to give users the most information possible at once. Ben
  21. 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 appreciated. FMPA 16.0.3 macOS 10.13.3
  22. 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, and sort every time In addition, it won't tell me 3 (The number of records after grouped by 'Type') Are there any easy tips to achive this in another way?
  23. 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-summary part which has the "SR_Average" field on it which summarises the average ranking for the group of keywords, when the list is sorted by date. (See attachment)  PROBLEM TO SOLVE:  I am trying to create a filtered portal on a related layout which only shows 1 row per month, showing just the month name, and the month average keyword ranking.  EG:  December 2013       8.5 January 2014         7.6 February 2014        7.6   Please help!
  24. 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 75cl $19 date2 75cl $19.5 date3 75cl $20 date4 1.5l $43 date5 1.5l $45 date6 1.5l $48 Then searching between date1...date6 would give etc. However, it is not working out the totals correctly eg it is not calculating the premium properly for the 1.5l format - it appears to group all of the values together.
  25. hi i have some questions to portals and how to make summaries. just a short description to what i´m working on. i´m an architect and i´m trying to integrate FM to my workflow. in this case I have an apartment building with 150 apartmnents. with my drawing program i´m generating a table for all rooms in the apartment building. i have a table with different informations (Fields) to rooms like ,RoomNr, Floor,Size, RoomHeight.....etc i made an other table to get different summaries of the apartments. i make a layout and place 3 portals. each of them are filtered and sorted to get the right rooms i need. my problem is i would like to have the summary field that show the total of the each sorted portal. is this possible to do it with the portals in one layout? all the summaries i get are always the total of all Rooms in the apartment, but not the summaries of the portals. the only way i get the right sum if i place the summery field in the portal itself, but then i get this information in every row of the portal (this is not the way i want). its something like this:(i´m looking for the red lines) Portal1: APP1 ROOM1 2,00m² APP1 ROOM2 4,00m² APP1 ROOM3 6,00m² SUM1:12,00m² Portal2: APP1 ROOM4 2,00m² APP1 ROOM5 4,00m² SUM2:6,00m² Portal3: APP1 ROOM6 10,00m² SUM3:10,00m² may be somebody could help me regards f.
  • Create New...

Important Information

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