Calculation Engine (Define Fields)

12,871 topics in this forum

1. Converting Excel Calculation to Filemaker - Stuck

   By vuego100, June 5, 2015
   • 2 replies
   • 655 views
   • 
   • vuego100
   • June 30, 2015

2. Calculate Number of Days in a Season from a Date Rage

   By Bobby Bradley, June 20, 2015   

   • date range
   • calculate
   • (and 1 more)

      Tagged with:

     • date range
     • calculate
     • days
   • 6 replies
   • 1.1k views
   • 
   • comment
   • June 21, 2015

3. Tally unique records

   By Greg Hains, June 18, 2015
   • 8 replies
   • 850 views
   • 
   • LaRetta
   • June 19, 2015

4. Creating Numerous Calculations Between Child Records

   By GisMo, June 16, 2015
   • 3 replies
   • 564 views
   • 
   • comment
   • June 16, 2015

5. Filemaker won't Calculate Fields unless drop down used

   By yilbber, June 10, 2015
   • 7 replies
   • 1.9k views
   • 
   • yilbber
   • June 15, 2015

6. Calculation to flag first record from a unique set

   By Stu412, June 15, 2015   

   • group
   • flag
   • 4 replies
   • 801 views
   • 
   • hbrendel
   • June 15, 2015

7. Comparison Operator Issue

   By Brad Knewstubb, June 15, 2015
   • 2 replies
   • 828 views
   • 
   • Brad Knewstubb
   • June 15, 2015

8. mac Charting new record count by month

   By obiejuankenobi, May 30, 2014
   • 6 replies
   • 170.8k views
   • 
   • nesor
   • June 13, 2015

9. Field does not show zero despite option unchecked in inspector

   By MSPJ, June 11, 2015   

   • fields
   • formatting
   • 2 replies
   • 1.1k views
   • 
   • MSPJ
   • June 11, 2015

10. Calculation field based on omitted record

    By Stu412, June 11, 2015   

    • found set
    • calculation
    • (and 1 more)

       Tagged with:

      • found set
      • calculation
      • omit
    • 2 replies
    • 1k views
    • 
    • Stu412
    • June 11, 2015

11. Determine Page Number of Previous Record using GetNthRecord

    By jayivan, June 10, 2015   

    • getnthrecord
    • layout logic
    • 6 replies
    • 1.5k views
    • 
    • jayivan
    • June 10, 2015

12. Formatting of zero result summary

    By Stu412, June 10, 2015   

    • summary
    • format
    • 3 replies
    • 769 views
    • 
    • eos
    • June 10, 2015

13. Force Dropped File to Show Icon

    By Chuck, June 8, 2015   

    • container-fields
    • 0 replies
    • 574 views
    • 
    • Chuck
    • June 8, 2015

14. What tab is active?

    By philfeldman, November 11, 2006
    • 6 replies
    • 3.1k views
    • 
    • fyanesv
    • June 7, 2015

15. What returns the inverse of the 'Log' function?

    By HALBURN, June 6, 2015
    • 3 replies
    • 745 views
    • 
    • HALBURN
    • June 6, 2015

16. Double booking based on date and time

    By sirmatter, April 20, 2015   

    • room assignment
    • 15 replies
    • 1.3k views
    • 
    • sirmatter
    • June 4, 2015

17. How do I code a thousands separator in a calc?

    By Rich S, June 28, 2010
    • 5 replies
    • 5k views
    • 
    • Lee Smith
    • June 3, 2015

18. counting the unique records

    By Aussie John, May 22, 2015
    • 4 replies
    • 660 views
    • 
    • Aussie John
    • June 2, 2015

19. Create fields using related records from another table?

    By wedgeman, June 2, 2015
    • 1 reply
    • 648 views
    • 
    • comment
    • June 2, 2015

20. Format in a FileMaker File

    By Ralph Schwegler, June 1, 2015   

    • date format
    • month day year
    • (and 2 more)

       Tagged with:

      • date format
      • month day year
      • mac | pc
      • startingpoint
    • 2 replies
    • 1.4k views
    • 
    • Ralph Schwegler
    • June 1, 2015

21. making one group out of similar values

    By Aussie John, June 1, 2015
    • 2 replies
    • 540 views
    • 
    • comment
    • June 1, 2015

22. Get ( ActiveModifierKey ) is intermittent

    By James Gill, June 15, 2011
    • 12 replies
    • 3.5k views
    • 
    • DanShockley
    • May 28, 2015

23. Calculate Day count given different duration dates

    By Miss A!, May 27, 2015   

    • dates
    • calculation counter
    • 4 replies
    • 913 views
    • 
    • Miss A!
    • May 28, 2015

24. Filtering a Schedule List by Period Number

    By luiscovar, May 26, 2015
    • 7 replies
    • 1.1k views
    • 
    • Fitch
    • May 27, 2015

25. How can I convert this timestamp into a FMP timestamp?

    By HALBURN, May 21, 2015
    • 8 replies
    • 2.8k views
    • 
    • comment
    • May 22, 2015

26. GetNthRecord

    By fmpfan, May 21, 2015
    • 7 replies
    • 1.3k views
    • 
    • comment
    • May 21, 2015

27. Portal Row sequencing?

    By Matthew R White, May 19, 2015
    • 4 replies
    • 705 views
    • 
    • Jeff M
    • May 20, 2015

28. Display Data from Second Related Record

    By datalink, March 16, 2015
    • 7 replies
    • 1.5k views
    • 
    • Jeff M
    • May 20, 2015

29. Help Me Understand this...

    By James Gill, May 19, 2015
    • 2 replies
    • 465 views
    • 
    • Josh Ormond
    • May 20, 2015

30. Simple calculation field does not work

    By John Chamberlain, May 19, 2015
    • 4 replies
    • 804 views
    • 
    • comment
    • May 19, 2015

31. Frequency and clusters of true or false

    By Phylum, May 16, 2015   

    • frequency
    • clusters boolean
    • 6 replies
    • 756 views
    • 
    • Phylum
    • May 17, 2015

32. Copy contents from 1 field to another

    By gfr92y, May 13, 2015
    • 5 replies
    • 838 views
    • 
    • gfr92y
    • May 17, 2015

33. Does anyone know how you store data in a Calculation field's "Repetitions"?

    By RoundtableSam, May 16, 2015
    • 16 replies
    • 1.1k views
    • 
    • RoundtableSam
    • May 17, 2015

34. Help... Repeating field calculation only pulling first related record

    By mrmacmusic, May 15, 2015
    • 2 replies
    • 773 views
    • 
    • mrmacmusic
    • May 16, 2015

35. Adding up only certain rows of a portal

    By etsmarines, May 15, 2015
    • 4 replies
    • 727 views
    • 
    • bruceR
    • May 15, 2015