Calculation Engine (Define Fields)

12,871 topics in this forum

1. Calculation help

   By Peter Frodell, March 18, 2016
   • 25 replies
   • 1.7k views
   • 
   • Peter Frodell
   • March 21, 2016

2. Count the number of values - Calculation

   By stutz, March 16, 2016
   • 3 replies
   • 896 views
   • 
   • stutz
   • March 17, 2016

3. Validation of Field AB123456

   By Tusif Ahmad, March 17, 2016
   • 2 replies
   • 1.4k views
   • 
   • Tusif Ahmad
   • March 17, 2016

4. Refreshing Calculations

   By Silez, March 15, 2016
   • 4 replies
   • 2.3k views
   • 
   • Fitch
   • March 15, 2016

5. Field Validation against a global field

   By Courtney, March 14, 2016
   • 4 replies
   • 1.2k views
   • 
   • comment
   • March 15, 2016

6. Sub Summary showing Individual Records

   By jagstirling, March 12, 2016
   • 2 replies
   • 878 views
   • 
   • jagstirling
   • March 12, 2016

7. Just a little help with a calc's syntax

   By Rich S, March 12, 2016
   • 0 replies
   • 755 views
   • 
   • Rich S
   • March 12, 2016

8. Number format - flummox

   By bdarch, March 11, 2016
   • 0 replies
   • 585 views
   • 
   • bdarch
   • March 11, 2016

9. Inventory

   By Rosalie, March 9, 2016
   • 5 replies
   • 1.1k views
   • 
   • Rosalie
   • March 10, 2016

10. Displaying Fields from one Record in Another Record

    By FileMike, March 8, 2016
    • 6 replies
    • 1.2k views
    • 
    • Lee Smith
    • March 9, 2016

11. Field calculation for text pattern

    By Miss A!, March 9, 2016   

    • pettern
    • calculation
    • (and 1 more)

       Tagged with:

      • pettern
      • calculation
      • text
    • 2 replies
    • 918 views
    • 
    • comment
    • March 9, 2016

12. Custom Field Validation if more that x Char

    By ibobo, March 7, 2016   

    • custom field validation
    • 9 replies
    • 1.1k views
    • 
    • ibobo
    • March 8, 2016

13. Price Matrix

    By Devin, March 5, 2016
    • 2 replies
    • 893 views
    • 
    • Devin
    • March 5, 2016

14. get current month in button bar calculation

    By Matthew R White, February 29, 2016
    • 3 replies
    • 925 views
    • 
    • comment
    • March 1, 2016

15. Simple Calc-Script Help

    By Philip Curtis, February 25, 2016
    • 4 replies
    • 1k views
    • 
    • Philip Curtis
    • February 25, 2016

16. Field validation when field is from external FMP data source

    By GC GYM, February 24, 2016   

    • external source data validation
    • 3 replies
    • 821 views
    • 
    • GC GYM
    • February 24, 2016

17. DNA custom function/calculation

    By oilcan, May 9, 2007
    • 12 replies
    • 2.1k views
    • 
    • PKF
    • February 23, 2016

18. Reverse FilterValues Result

    By xeb, February 19, 2016
    • 2 replies
    • 1.2k views
    • 
    • comment
    • February 19, 2016

19. Sort table by initial row or most current date

    By Matthew R White, February 9, 2016
    • 4 replies
    • 810 views
    • 
    • Matthew R White
    • February 19, 2016

20. summarizing data in a portal timesheet database

    By John Kostenbader, February 17, 2016   

    • timesheet
    • summarizing hours
    • 6 replies
    • 1.7k views
    • 
    • comment
    • February 18, 2016

21. Can you we used a fusion or other variable substitution in a formula?

    By SHMUEL, February 7, 2016   

    • substitution
    • fusion
    • 4 replies
    • 1.1k views
    • 
    • SHMUEL
    • February 9, 2016

22. Calculating blocks of time

    By madman411, February 8, 2016
    • 5 replies
    • 939 views
    • 
    • comment
    • February 9, 2016

23. Add an "and" to a list

    By rick altman, February 5, 2016   

    • substitute
    • position
    • (and 2 more)

       Tagged with:

      • substitute
      • position
      • script
      • function
    • 1 reply
    • 1.2k views
    • 
    • LaRetta
    • February 5, 2016

24. Filepath based on field entry

    By chadski021, February 2, 2016
    • 3 replies
    • 916 views
    • 
    • Lee Smith
    • February 3, 2016

25. mac How to create page count

    By brobins, March 18, 2014
    • 19 replies
    • 9.4k views
    • 
    • LaRetta
    • February 2, 2016

26. Remove Quotation marks from non alpha characters

    By innodat, January 28, 2016   

    • calculation
    • text
    • (and 1 more)

       Tagged with:

      • calculation
      • text
      • quotation marks
    • 10 replies
    • 1.6k views
    • 
    • innodat
    • January 29, 2016

27. Running total of all sales in first quarter, second etc

    By FMData12, January 29, 2016   

    • sales
    • running
    • (and 2 more)

       Tagged with:

      • sales
      • running
      • total
      • quarter
    • 0 replies
    • 545 views
    • 
    • FMData12
    • January 29, 2016

28. WeekOfYear ISO 8601

    By ralph.nusser, February 26, 2005
    • 9 replies
    • 2k views
    • 
    • Patrick ONeill
    • January 27, 2016

29. Days overdue not taking the year into account

    By D4v3, January 25, 2016   

    • due date
    • 12 replies
    • 1.3k views
    • 
    • Lee Smith
    • January 26, 2016

30. Modifiable Repeating Field Entries?

    By steveald, January 21, 2016   

    • global fields
    • repeating fields
    • (and 1 more)

       Tagged with:

      • global fields
      • repeating fields
      • modify repeating field values
    • 15 replies
    • 1.5k views
    • 
    • comment
    • January 25, 2016

31. Calculation result depends on date query

    By Gogargirl, January 21, 2016   

    • calculation
    • date range
    • 4 replies
    • 1.4k views
    • 
    • Gogargirl
    • January 25, 2016

32. Separating info into seperate fields

    By Ben Ball, January 22, 2016
    • 1 reply
    • 618 views
    • 
    • comment
    • January 22, 2016

33. User Name Calc

    By Bikeman17, January 21, 2016
    • 3 replies
    • 720 views
    • 
    • bcooney
    • January 21, 2016

34. Is it possible to find and compare different records in a calculation?

    By Vliet057, January 21, 2016
    • 7 replies
    • 681 views
    • 
    • comment
    • January 21, 2016

35. Displaying a count of related records within a parent record

    By davidnickerson, September 21, 2015
    • 6 replies
    • 971 views
    • 
    • comment
    • January 21, 2016