Calculation Engine (Define Fields)

12,867 topics in this forum

1. How do I extract a string from a field that matches a text field in one of the records from another table?

   By johnfromberkeley, June 28, 2016
   • 3 replies
   • 642 views
   • 
   • comment
   • June 29, 2016

2. Tax Calculation

   By ZippyT, June 24, 2016
   • 3 replies
   • 853 views
   • 
   • ZippyT
   • June 24, 2016

3. Converting Text to Date

   By dav1089, June 22, 2016   

   • calculation
   • text to date
   • (and 1 more)

      Tagged with:

     • calculation
     • text to date
     • getasdate
   • 2 replies
   • 939 views
   • 
   • dav1089
   • June 23, 2016

4. How to Select Randomly between a range of numbers

   By Maclurv, June 18, 2016
   • 2 replies
   • 880 views
   • 
   • Maclurv
   • June 18, 2016

5. Check whether Date is within a Date range

   By Tissot, July 1, 2008
   • 25 replies
   • 10.4k views
   • 
   • LaRetta
   • June 17, 2016

6. char(number) not working as I expected...

   By philipcaplan, June 16, 2016
   • 1 reply
   • 726 views
   • 
   • comment
   • June 16, 2016

7. Converting decimal values into proper time format

   By McScripta, June 15, 2016
   • 12 replies
   • 1.3k views
   • 
   • McScripta
   • June 16, 2016

8. Different scripting result depending on Filemaker version, 13, 14, 15

   By Tompa79, June 13, 2016
   • 3 replies
   • 766 views
   • 
   • Wim Decorte
   • June 13, 2016

9. summary count over several fields

   By beckham, June 13, 2016
   • 1 reply
   • 721 views
   • 
   • comment
   • June 13, 2016

10. Filed name ending in space on cvs file

    By adrianatwork, June 11, 2016   

    • field
    • csvfile
    • (and 1 more)

       Tagged with:

      • field
      • csvfile
      • space
    • 4 replies
    • 1.1k views
    • 
    • comment
    • June 12, 2016

11. Calculation across related tables.

    By charisse, June 8, 2016
    • 11 replies
    • 956 views
    • 
    • comment
    • June 10, 2016

12. Counting tasks due

    By Smiley, June 8, 2016
    • 5 replies
    • 615 views
    • 
    • comment
    • June 8, 2016

13. Date range calculation criteria

    By Miss A!, June 8, 2016   

    • date ranges
    • date calculation
    • (and 1 more)

       Tagged with:

      • date ranges
      • date calculation
      • calculation statements
    • 2 replies
    • 1.8k views
    • 
    • Miss A!
    • June 8, 2016

14. Counting records between NOT directly linked tables (1 & 3)

    By AGilek, June 7, 2016   

    • count
    • records
    • (and 3 more)

       Tagged with:

      • count
      • records
      • linked tables
      • self-join
      • calculation field
    • 2 replies
    • 1.2k views
    • 
    • AGilek
    • June 8, 2016

15. Hiding objects on multiple rules

    By Smiley, June 2, 2016
    • 11 replies
    • 4.7k views
    • 
    • Josh Ormond
    • June 7, 2016

16. Go to portal row

    By Philip Jenks, June 6, 2016   

    • portal row
    • 12 replies
    • 4.4k views
    • 
    • Ron Cates
    • June 7, 2016

17. Calculation

    By indy4300, June 4, 2016
    • 8 replies
    • 733 views
    • 
    • indy4300
    • June 4, 2016

18. Fuel Consumption

    By Ninja, June 1, 2016
    • 6 replies
    • 1.1k views
    • 
    • comment
    • June 3, 2016

19. Rounding a summary field

    By indy4300, June 2, 2016   

    • rounding
    • 2 replies
    • 1.1k views
    • 
    • indy4300
    • June 2, 2016

20. Counting Number of pages when printing

    By Smiley, June 2, 2016
    • 3 replies
    • 592 views
    • 
    • comment
    • June 2, 2016

21. Seperating A Address Field

    By Kevin Roach, June 2, 2016
    • 1 reply
    • 674 views
    • 
    • comment
    • June 2, 2016

22. Rounding a summary field

    By indy4300, June 1, 2016   

    • filemaker pro calculation round up
    • 3 replies
    • 657 views
    • 
    • indy4300
    • June 1, 2016

23. Combo-box Table Lookup Value

    By Hellmut, February 25, 2006
    • 14 replies
    • 3.7k views
    • 
    • comment
    • June 1, 2016

24. Portal Calculation help

    By atlanticind, May 31, 2016   

    • portal
    • calculation
    • 1 reply
    • 1.1k views
    • 
    • Lee Smith
    • May 31, 2016

25. Remove .JPG Extension from File Name

    By Agentshevy, May 24, 2016   

    • substitue
    • custom function
    • (and 1 more)

       Tagged with:

      • substitue
      • custom function
      • scripting
    • 4 replies
    • 4k views
    • 
    • Agentshevy
    • May 25, 2016

26. Correct syntax for calculating an average in a Sub Summary report.

    By Twizzle, May 16, 2016
    • 2 replies
    • 711 views
    • 
    • Twizzle
    • May 17, 2016

27. Reports and averages

    By mrafs, October 21, 2003
    • 3 replies
    • 997 views
    • 
    • Twizzle
    • May 16, 2016

28. automatic calculations

    By Atefe, May 15, 2016
    • 3 replies
    • 911 views
    • 
    • comment
    • May 15, 2016

29. Annual Rest Auto Enter Serial Number

    By Ocean West, May 15, 2016
    • 0 replies
    • 557 views
    • 
    • Ocean West
    • May 15, 2016

30. Two fields drop down list

    By bishop7262, May 14, 2016
    • 1 reply
    • 582 views
    • 
    • Lee Smith
    • May 14, 2016

31. subtract x number of work days from date

    By Devin, May 13, 2016
    • 2 replies
    • 809 views
    • 
    • comment
    • May 13, 2016

32. Checkbox portal logical AND function?

    By Filebreaker, May 6, 2016   

    • checkbox
    • logic
    • 4 replies
    • 1.5k views
    • 
    • Filebreaker
    • May 6, 2016

33. Count Related Records Conditionally

    By Courtney, May 5, 2016
    • 2 replies
    • 660 views
    • 
    • Courtney
    • May 5, 2016

34. GetSummary of Hours in a Range using Calculation Field

    By cbombeck, May 4, 2016   

    • getsummary
    • calculation field
    • 3 replies
    • 1.3k views
    • 
    • Steve Martino
    • May 5, 2016

35. Number Notation

    By AnthonyDixon, May 3, 2016
    • 7 replies
    • 1.2k views
    • 
    • AnthonyDixon
    • May 3, 2016