Calculation Engine (Define Fields)

12,872 topics in this forum

1. Help to calculate Sub Total field of found records

   By beckham, March 21, 2016
   • 1 reply
   • 655 views
   • 
   • comment
   • March 21, 2016

2. Calculation help

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

3. Count the number of values - Calculation

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

4. Validation of Field AB123456

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

5. Refreshing Calculations

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

6. Field Validation against a global field

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

7. Sub Summary showing Individual Records

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

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

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

9. Number format - flummox

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

10. Inventory

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

11. Displaying Fields from one Record in Another Record

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

12. Field calculation for text pattern

    By Miss A!, March 9, 2016   

    • pettern
    • calculation
    • (and 1 more)

       Tagged with:

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

13. 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

14. Price Matrix

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

15. get current month in button bar calculation

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

16. Simple Calc-Script Help

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

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

    By GC GYM, February 24, 2016   

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

18. DNA custom function/calculation

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

19. Reverse FilterValues Result

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

20. Sort table by initial row or most current date

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

21. 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

22. 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

23. Calculating blocks of time

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

24. 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

25. Filepath based on field entry

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

26. mac How to create page count

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

27. 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

28. 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
    • 573 views
    • 
    • FMData12
    • January 29, 2016

29. WeekOfYear ISO 8601

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

30. Days overdue not taking the year into account

    By D4v3, January 25, 2016   

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

31. 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

32. Calculation result depends on date query

    By Gogargirl, January 21, 2016   

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

33. Separating info into seperate fields

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

34. User Name Calc

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

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

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