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 the count in the toolbar (i.e. 516 unsorted) counts them all. I understand that the serial numbers and toolbar count are for “records.” But I want a total count of my movies, excluding duplicates.
What I’ve done is create a checkbox for duplicates. If the box is checked, then of course, the movie is a duplicate. Is it possible to create a field that has a running count of the movies in my collection, EXCLUDING the duplicates? If it is possible, what is the procedure from omitting them from any such subtotal, summary, or running total?
Thank you! PT
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.
I am attempting to use the following script in a Database:
Set Variable [$supplierCount; Value: ValueCount ( List ( Suppliers::UUID ) )] Set Variable [$month; Value: MonthName ( Get ( CurrentDate ) )] Set Variable [$suppliers; Value: List ( Suppliers::UUID )] Loop Set Variable [$i; Value: $i+1] Exit Loop If [$i > $supplierCount] New Record/Request Set Field [Month::Month; $month] Set Field [Month::fk_Supplier; GetValue ($suppliers ; $i )] End Loop
When I run it, however, it creates zero New Records within my "Month" database.
I'm not sure what the issue is. My only hunch is that the List function isn't properly creating a List of the "Suppliers::UUID" field, and is causing the ValueCount taken of it to return 0.
Please let me know of any additional information I can provide, and thank you in advance for any assistance you can offer!
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.
Who Viewed the Topic1 member has viewed this topic:Wickerman