Calculation Engine (Define Fields)

12,878 topics in this forum

1. Conditional Sum of Numbers

   By life036, April 9, 2011
   • 7 replies
   • 1.6k views
   • 
   • life036
   • April 14, 2011

2. monthly attendance tracking

   By adamkarwowski, March 30, 2011
   • 4 replies
   • 2.1k views
   • 
   • ItsJustMe
   • April 14, 2011

3. Removing and Retaining Lines from a Multi-Line Field based on a Keyword

   By jlev, April 9, 2011
   • 5 replies
   • 930 views
   • 
   • jlev
   • April 12, 2011

4. Date Calculation

   By Alanj, April 12, 2011
   • 4 replies
   • 799 views
   • 
   • Alanj
   • April 12, 2011

5. Auto entera field based on Date+1 calculation?

   By dbfreak, April 11, 2011
   • 1 reply
   • 666 views
   • 
   • comment
   • April 12, 2011

6. Get(LayoutName) calculation in case statement

   By Mike CPB, April 8, 2011
   • 2 replies
   • 986 views
   • 
   • Mike CPB
   • April 8, 2011

7. Text from a field as validation calculation

   By Woodnote, April 7, 2011
   • 5 replies
   • 1.2k views
   • 
   • Woodnote
   • April 8, 2011

8. Text Parsing (IP Address)

   By tomg3, March 25, 2010
   • 8 replies
   • 3.4k views
   • 
   • comment
   • April 7, 2011

9. Is this a bug?

   By TrulySimple, April 5, 2011
   • 26 replies
   • 2.8k views
   • 
   • TrulySimple
   • April 7, 2011

10. Calc step for "includes this text"?

    By Ian Murphy, April 6, 2011
    • 2 replies
    • 659 views
    • 
    • Ian Murphy
    • April 6, 2011

11. Struggling with simple calc

    By James Gill, April 6, 2011
    • 3 replies
    • 663 views
    • 
    • comment
    • April 6, 2011

12. Letter from field

    By Pavel Smirnov, April 2, 2011
    • 5 replies
    • 1.4k views
    • 
    • Vaughan
    • April 6, 2011

13. Case statements

    By tokkajy, April 5, 2011
    • 3 replies
    • 1.2k views
    • 
    • Fitch
    • April 5, 2011

14. Creating a Data Dictionary in FMP9

    By david.michaels, April 5, 2011
    • 1 reply
    • 1.1k views
    • 
    • Fitch
    • April 5, 2011

15. Creating Percentages

    By placebo, April 5, 2011
    • 1 reply
    • 636 views
    • 
    • comment
    • April 5, 2011

16. Substitute % + number

    By FMReader, March 31, 2011
    • 6 replies
    • 1.6k views
    • 
    • FMReader
    • April 2, 2011

17. Another "Sum of related fields" question

    By gseymour, March 29, 2011
    • 9 replies
    • 1.4k views
    • 
    • gseymour
    • April 1, 2011

18. UniqueValue_Sum - Inconsistent inaccurate counts

    By TrulySimple, April 1, 2011
    • 4 replies
    • 1k views
    • 
    • TrulySimple
    • April 1, 2011

19. Limit New Records on a Layout

    By Shipbuilder, March 30, 2011
    • 11 replies
    • 1.6k views
    • 
    • Shipbuilder
    • March 31, 2011

20. Change Excel Formula to Filemaker Calculation

    By zdub, March 30, 2011
    • 1 reply
    • 2.4k views
    • 
    • comment
    • March 31, 2011

21. User text used AS the Calculation

    By mike60640, March 30, 2011
    • 2 replies
    • 623 views
    • 
    • mike60640
    • March 30, 2011

22. Dates to chart box number

    By peptoulcer, March 30, 2011
    • 0 replies
    • 599 views
    • 
    • peptoulcer
    • March 30, 2011

23. Replace calculation in text block

    By Shedboyxx, March 28, 2011
    • 2 replies
    • 629 views
    • 
    • Shedboyxx
    • March 29, 2011

24. Global Field Work-Around

    By JLC, March 29, 2011
    • 2 replies
    • 1.6k views
    • 
    • Josh Ormond
    • March 29, 2011

25. SumIF

    By isateng, March 26, 2011
    • 1 reply
    • 1.2k views
    • 
    • bcooney
    • March 26, 2011

26. Automatically Update Summary and Calculation Fields

    By dtsparky, April 23, 2008
    • 3 replies
    • 1.6k views
    • 
    • R2D2
    • March 26, 2011

27. midpoint of date and time

    By mrmogway, March 26, 2011
    • 6 replies
    • 3.9k views
    • 
    • mrmogway
    • March 26, 2011

28. Sum from related TO

    By Oyseka, March 25, 2011
    • 2 replies
    • 1.3k views
    • 
    • Oyseka
    • March 26, 2011

29. Calculation to auto-fill date based on checkbox

    By mrswombat, March 24, 2011
    • 6 replies
    • 2.3k views
    • 
    • mrswombat
    • March 24, 2011

30. Simple True/False Checkbox

    By chrisknight55, March 24, 2011
    • 2 replies
    • 1k views
    • 
    • chrisknight55
    • March 24, 2011

31. Locating most current date in Found Set

    By Shipbuilder, March 24, 2011
    • 2 replies
    • 941 views
    • 
    • Shipbuilder
    • March 24, 2011

32. Calculations & Summarizing Data

    By Raschelle, March 24, 2011
    • 0 replies
    • 907 views
    • 
    • Raschelle
    • March 24, 2011

33. time interval calculation

    By Cateleb, March 23, 2011
    • 7 replies
    • 1.6k views
    • 
    • Cateleb
    • March 24, 2011

34. Formula that can calculate how many syllables are in a given word?

    By HALBURN, March 22, 2011
    • 1 reply
    • 2.9k views
    • 
    • HALBURN
    • March 23, 2011

35. Text spacing

    By Pavel Smirnov, March 23, 2011
    • 1 reply
    • 1.5k views
    • 
    • Vaughan
    • March 23, 2011