Jump to content

Search the Community

Showing results for tags 'calculations'.

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 33 results

  1. I have a Layout in Table Mode as (partially) shown in the attachment. (Note: First row will have a Country Code in it - not shown in attachment) I want to "fill-down" the last country code in all rows (in the Country Field) UNTIL the country code changes. Then I want to similarly do it for that one. Until I reach the end of rows. My database will grow from 500 to 10,000 rows of text/number data. I am uploading in batches from Excel. Is this possible? I've tried various calculations and scripting without much success. Thanks! I'm trying to get something like this: COUNTRY IT IT IT IT IT IT IT IT ES ES ES ES ES AU AU AU AU AU IN IN IN IN .......etc
  2. Using an auto-enter calculation on a field is a great way to populate its contents when other fields are modified, including itself. But what do you do if you want to use a calculation that references itself without having it trigger its own auto-enter calculation? The answer lies in thinking outside the calculation.... Read the Full Article Here…
  3. Placeholder text is a great new feature in FileMaker 14. With it you can specify by calculation what label text is to appear in a field that is empty. You can also have complete control over the styling of that text. In this article we demonstrate how to setup a placeholder and some of its benefits over standard labels. We also show how placeholder text can be used as a powerful user interface tool for displaying virtually any calculated value direct on a layout without the need for fields or variables. Click here to check out the full article at FileMaker Weetbicks
  4. hi i have a table with 4 fields field 1 = number result 1 field 2 =number result 2 field 3= percentage result field 4 = calculation by taking in whichever is lower field 1 or 2 and multiplying by field 3 the question now is how do i script the calculation it should pick up which ever is lower but ignore if field is empty. i hope i am clear , i would appreciate if someone could help me out with this calculation.
  5. I'm trying to develop a Sports Competition Management System, which ties in with a few other features for my sports association. We have a number of leagues, based on Gender, Age, etc. which vary in team numbers, for example some leagues may have 12 teams, other only 7. Some teams play each other only once per season, other two + times, it depends on the size of the league. I have a few scripts which combined build the schedule of games (Time, Date, Round of Play) and my next step is how to create a Balanced Schedule for an Even Number of Teams, or a Cyclic Schedule for Odd Number of Teams. Obviously, an IF function determines which Scheduling Algorithm to use, based on the number of teams in that particular league. My problem now is to automatically assign the teams participating in the matches, in a way described at the following links I assume it involves a rather complex calculation at some point in the script, but after searching high and low for some inspiration, and a few trial and error attempts... Nothing tangible to show for it. Even # of Teams (Balanced) Odd # of Teams (Cyclic) My file can be downloaded from this link https://www.dropbox.com/s/3onnzm4w75s08r2/Association%20Admin.fmp12 Thanks in Advance
  6. Hello All! I am having trouble building a complex subsummary report efficiently for a real estate database. The report layout is simple: I basically have a layout with 18 columns, all years, 2000-2017. The layout only has subsummary parts, no body parts. The subsummary part I am using to display data is sorted by a field called Micromarket (basically a geographical area). I want to display the number of units built in each year for each Micromarket. I have the report working perfectly, but I had to add many fields to my property table to accomplish this. The fields are as follows: Field Name: Number_of_Units_2000: Calculation: If ( (Year_Built)=2000;Number_of_Units ) and a corresponding Summary field that is the "Total Of" Number_of_Units_2000. I have done this for each year on the report, so I have made 18 Calculation fields, and 18 corresponding Summary fields. I then put each Summary field in its corresponding column on the layout, and for each Micromarket, I am able to display the number of units added in a given year. Is there a more efficient way to do this? I have tried performing a different find for each year within a script, then populating a Merge Variable with the result, but the Merge Variable doesn't behave the same way on the layout as a Summary field does. Any help would be appreciated!
  7. I have the following: Table 1 – Expenses Field A: Date Field B: Concept Field C: Amount Table 2 – Flight Time Field D: Date Field E: Flight Time (in hours) I need a report that will give me the expense cost per hour, i.e. the total of Field C divided by the total of Field E. Table 1 and Table 2 are not related. What relationship must I establish between them to obtain my desired result? If establishing a relationship between the tables is not the answer, how else can I achieve the figure I need? Thank you for any help that can be provided.
  8. There are three tables: Services ServiceTransactions ServiceTransactionLineItems Relationships: Services:materialName::ServiceTransactionsLineItems:Material_FK and Services:MaterialYear::ServiceTransactionLineitems:TransactionLineItemYear (Services may change from year to year, and within one transaction you might line items for both current and future years.) ServiceTransaction:TransactionNumber::ServiceTransactionLineItems:TransactionFK :Services:MaterialBudgetAllocation is a user entered number. What I am hoping to do is: Get the yearly total amounts of each material (Material_FK) and subtract that from Services:MaterialBudgetAllocation to get a remaining amount.
  9. I am trying to chart and analyze sale data. In particular, "Most popular product(from a specific product category) this quarter/month/year/etc" and things of that nature. In this database there are several tables: I will try to explain how they are linked Sales Order -Sales Order Line Item --Product Product Category -Product --Sales Order Line Item For example, I want to see the most popular product during a certain fiscal quarter do do so, I need to filter the line items by the following criteria and then have a calculation of the sum of found line items grouped by product * order quantity: Based on the tables this criteria needs to be met: SalesOrder::OrderStatus /= "Open" (not equal) (i.e. closed/completed orders) SalesOrder::Year=CurrentYear SalesOrder::Quarter = Fiscal Quarter(or can be month or can be omitted entirely) Product::Category="my category"(whatever) I've tried many solutions and getting somewhat close, but I get stuck with Un-Index-able match fields(keys) dues to calculations from related tables or circular references. Any tips would be great. Lastly, I think I can accomplish the same thing with a script and perform multiple searches against the LineItems based on related tables, but wanted to know if there is a more direct way via the relationship graph. I'm happy to provide more details if needed. Thanks in advance.
  10. This is probably an easy design concept, but my dense brain isn't seeing it. I'm working on a timecard system, and I'm running into a problem where I have co-dependent fields. In my hours table, I have a field which calculates the amount of VTO (Variable Time Off - like vacation time) that is used if the total hours entered on a workday is less than 8. However, the system can only fill the deficit in hours (8 - hours worked) if you have enough VTO available, so the calculation first checks the value of the VTO_Available field from the related VTO_Month table. It looks like this: Let ( [ Worked = TotalHours; Deficit = 8 - TotalHours ]; Case ( Worked >= 8; 0; //No VTO needed to fill in for the current date Deficit > 0 and (VTO_Month::VTO_Available >= Defict); Deficit; //If there is enough available VTO to cover the time deficit, return the amount of the deficit Deficit > 0 and (VTO_Month::VTO_Available < Deficit); VTO_Month::VTO_Available; //If some VTO is available, but not enough to cover the deficit, use up the available amount (take to zero) 0 //Otherwise, you can't use any VTO if you don't have any! ) ) //End of Let In the VTO_Month table, the VTO_Available field is calculated as (VTO_Start + VTO_Earned) - VTO_Used. VTO_Used is a calculated field defined as Sum (Hours::VTO_Today). Obviously, I can't have two fields whose values depend on each other, but I can't think of how to set up the design to avoid this problem. I seek your guidance! Help me get to that moment where I smack my forehead and say, "Duh! I should have been able to figure that out!"
  11. There is probably a simple solution to this problem that I'm not seeing but I've read through my entire 900 page FileMaker Pro Missing Manual and I can't find the appropriate answer; I'm using FMP 13 Advanced and I have some basic experience writing scripts, etc. Here's The Goal: To start each day with a screen report of tasks to complete for my client files. I want a report that says 'today you must take care of the following items..." To keep it simple, I have a client table & a transaction table. For each transaction that I handle for my client there is at least 25-35 documents to complete. Certain documents are completed at the time of sale and other to be done during & after the sale over several week's time. It's difficult to keep track of what forms have been completed. Also I could be handling several sales at the same time compounding the administrative challenge. I do this manually now. Currently I use a simple chart layout with checkboxes that I manually fill in as each task is completed for each sale but I'd like to have it automated with daily reminders of forms still needing to be signed today, 1 day from now, 7 days from now, etc. It's easy to create a single date calculation field that says I have "X" number of days until the deadline for one item but can I do this for 25-35 reminders and ... (Here's the challenge) have a daily report telling me what is still due? I'm thinking I may have to create a "task" table that would have a related record for each one of the forms I need to complete on each client and have it connected to my transaction table. Then a script to search all relevant dates across all records. But that seems like so much redundancy to have 30+ records for one transaction file. Is there an easier way? Thanks in Advance!
  12. 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
  13. Hello, I've been using filemaker for quite some time and tried to use it to build a "backtimer" log for Live television applications. however, after much searching, i cannot find a "real time running clock" function or plug in that allows a field to be updated with the "current time" in real time(system clock every second). a script does now work for my application as i need to be able to use the database to type notes as the time calc runs in the background. I have not been able to get a web viewer window to work because i still need a script to update the field every second. In my search i have read several times that filemaker cannot do this. I find this hard to believe. Any help is much appreciated. Thx,
  14. I have a checkbook journal with a calc that figures the balance. I know this should be easy, but I am having a hard time figuring out how to capture the balance daily (the end of the day) and do a simple report, list, or portal that shows the daily balance. ((kind of what you see when logging in to your bank). Any ideas anyone? Than you in advance. Amy
  15. I have a table where we do our estimates. This table is used by 10 people. The estimates are comprised of estimates made by telephone, by email, and by a physical person entering our office. I have already created calculations and summaries in this table, even with the percentages for each type of estimate based on the total estimates. I have another table with the the actual contracts that have been made and the summary count of contracts made by each person. This table is used by the same 10 people. Now i need to make another table to give me the summaries of all the data from above by month. The percent of estimates that have become contracts and etc. My problem is with the relationship and the fields in the new table. I am wondering how to do this correctly? Dave
  16. FileMaker Coaches' Corner - Tip 11 - Improve Performance - FileMaker - FileMaker Experts https://youtu.be/5D2qoA_S7u8 Get up to speed with the FileMaker Pro 17 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com If you want to explore building I.O.S apps for I Phone or I Pad and deploying those out to the Apple App Store. Here is a video introduction to our iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw Looking for FM Starting Point free software download: http://www.fmstartingpoint.com For More Free FileMaker Videos Check out Http://www.filemakerfree.com Visit http://www.learningfilemaker.com for all facets of FileMaker Award Winning Video Training. Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There. Please Comment, Like & Share All of Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos Filemaker Pro 17 Training Videos FileMaker 17 Videos Filemaker Pro 17 Video Course #FileMakerVideos #FileMakerTrainingVideos #WhatisFilemaker17 #FilemakerPro17Training #Filemaker17VideoTutorial #FilemakerPro17Videos #FileMakerCoaches'CornerTip11
  17. Hello, I am new to FileMaker and still trying to find my way around the scripting language. Even though the scripting language is quite rich, I don't feel as comfortable and flexible as I do in lets say VB. To my query now; I have designed a solution for my company which processes invoices. These invoice forms input numerical amounts tied on budget codes for each department and in turn are stored in a different table. As you can see on the image attached, I cannot find a calculation function that will sum all the amounts for each BudgetCode into AmountAllocated. AmountAssigned is the yearly department budget predefined. I will be grateful for any suggestions or ideas. Thanks
  18. Hello, first time poster and FM newbie. I'm creating a DB that tracks sales for a small retail sales team. One table called "Quarter" contains a primary key called "__kp_Quarter" which is a unique identifier of a fiscal quarter. An example would be "2012 Q1". There are also two fields, startDate and endDate, which the user sets to the start and end dates of the quarter. This is entrusted to the user because lengths of fiscal quarters may vary. In another table called "Sale," which tracks individual sales, there is a "Date" field. This is also edited by the user, because some sales are backdated. I'd like to have the field _kf_Quarter, where the content is auto-entered by detecting which quarter's date range contains the sale's date. How is this possible? Is there a better method to track sales by fiscal quarter?
  19. Hi, I have a field in a db that has a value list attached to it and checkboxes. I need to make calculation fields that will look at the field and if it contains certain text, will put "T" in the calculation field. Field Name: FEDHAZ Value List Name: Hazard Category Values: a. Fire b. Reactive c. Pressure Release d. Acute Health e. Chronic Health Since a chemical can have more than one of these values, and be checked in any order, there's quite a bit of variation as to what text the field can contain. I need to make a field, Acute, that if the field contains the "d. Acute Health" text, it will fill the Acute field with the letter "T". I could say: If (FEDHAZ = "d. Acute Health"; "T"; "" However, as you know, that will only work if the only item checked is that one. How can I get the same result no matter which other ones have been checked? Something similar to: IF (FEDHAZ contains "d. Acute Health"; "T" "" What function could I add for "contains"?
  20. Below is an image of my Script. Problem Area:(Highlighted in Yellow) Set Field [Table::Vehicle_Description1; $&"VD&$i Goal: Variables $VD1-$VD8 are holding data. I am doing a loop $i which is a counter that increments from 1 to 8. If there is Data within the variable then I want the field Vehicle_Description1 to be filled with $VD1 on the 1st iteration. Current Output: When running the script, assuming data is in $VD1, I am getting VD1 within Vehicle_Description1 instead of what data is within the variable $VD1. What is unusual: The counter $i is working fine. You can see this with the output VD1 InShort: How do you read a variable when you have to concatenate and read a dynamic variable? Any help or suggestion would be much appreciated.
  21. Hi guys, I’m brand new working with FM and would like your help with a calculation if I may. I want a calculation to display an estimated number of paint tins needed to paint a boat based on it’s length and width. With this information I would also like the cost of the estimated paint. I'm assuming IF can not be used as there are too many variables, can CASE? With the boats width, I've got anything over 7 classed as wide, so I've been using Jobs::BoatWidth > 7 to define narrow and wide (only two classes of widths). I'm using the table below to give our customers a rough idea at the moment but would like information to be displayed in FM specific to boats length and width for each customer after entering that data: Jobs::BoatWidth and Jobs::BoatLength. Cost of each tin is £26.32. Hope I haven't left anything out and thanks in advance.
  22. Hello! I am trying to write a simple calculation that is proving to be more difficult than I thought. I have a real estate database with the tables: properties, transaction, and people. A property can have multiple transactions associated with it, and each transaction has people attached to it (buyer, seller, broker). I am trying to flag all the properties (in the properties table) when a certain person is linked to any of the properties associated transactions, call this person "Bill". Taking it one step further, I would like to display a "C" when the Bill is associated with a transaction with the status of "Closed" and a "L" when Bill is associated with a transaction with the status of "On Market". That is easy enough and I have that portion working (in the transaction table). The problem is I want the "C" to be prioritized, meaning if Bill is associated with two or more of the associated transactions for one property, and one of those transactions status is "Closed", and the other is "On Market", I would like a "C" to be displayed in the property table. The way it is set up now, I can only seem to look at the most recent transaction (based on closing date) and display either a "C" or "L" depending on the status of the most recent transaction. Sometimes the transaction with the status "Closed" is more recent and vise versa. How can I set this up so that the calculation looks at all related transaction records, determines if any are flagged with either a "C" or an "L", and if there are both, display the "C"? Any help would be appreciated!
  23. Hi all, I'm hoping you can help here. I am trying to make a calculation on a layout. I need to calculate measurements of a specific drop down value that I write in a specific field. The value is called "pool." There are other values called "rapids" and "riffles" etc., but I need to write a calculation that finds running totals of the lengths between the "pools." Is it easier to run a script? If so, how to do I do this? FYI- I have another field that gives unit lengths. Again, I want to calculate the unit lengths between the value "pool". I hope this is clear enough. Ideas? Thanks!
  24. Our database has a quotation table. We have a drop down menu for products and one for quantity, total and price. The price field is a calculation field which the calculation is If (Product = "A2 Poster" ; "£10) which works fine. However obviously we have more than one product we sell, when i try to put another product calculation next to this it does not work. How can i have multiple calculations in the price field for each drop down in "Product field"
  25. Hi! I have an Hours Sheets table, and hour sheets are created per month. I have Absences table which has absences specified by start and end date. and I have a Calendar days table, which is related with Absences with start date and end date. Now, When I create an absence spanning over two or more months, (e.g 26th March to 5th April) I want to get related calendar days for the particular month in hour sheet. (i.e if I create an absence from 26th March to 5th April I want to have 3 days (26th, 27th and 28th) in hours sheet of February month and 5 days (1st, 2nd, 3rd, 4th and 5th) in hours sheet of March. I am not able to find a way to separate out the days based on a month. ( I can not use portal filter, since I need the days to use in calculations) I have attached a sample file. Any advice/suggestions will be greatly appreciated. Thanks! absences.fmp12.zip
  • Create New...

Important Information

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