Search the Community
Showing results for tags 'summary'.
-
Hi guys! I hope someone can help me with this. I have a SUMMARY LIST field which contains types of items eg. (shoes, shoes, sneakers, boxers, jumpers, boxers, jackets, shoes, sneakers...). These items are also listed in a value list (boxers, jumpers, shoes, jackets, sneakers) Is ther... -
Hi all - In our Filemaker database, we have an "Appointments" table and an "Appointment Services" table (being one or more services linked to an Appointment). I am working on a print layout to list all the Appointments on a given date, with a sublist of the Appointment Services for each appoint...
-
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 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....
-
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).... -
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...
-
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 ca...
-
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 th...
-
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...
-
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 i...
-
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 Gr... -
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?
-
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... -
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 Fil... -
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...
-
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...
-
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 te...
-
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 t...
-
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 l... -
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 b...
-
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"...
-
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... -
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 pla...
-
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...
-
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...
