Calculation Engine (Define Fields)

12,875 topics in this forum

1. mac Case Statement

   By Jonah74, May 17, 2018
   • 6 replies
   • 3k views
   • 
   • Fitch
   • May 17, 2018

2. related table matching Filed?

   By Devin, May 12, 2018
   • 6 replies
   • 820 views
   • 
   • siroos12
   • May 14, 2018

3. RelationInfo function not working in my file

   By Tom R., April 29, 2018
   • 0 replies
   • 755 views
   • 
   • Tom R.
   • April 29, 2018

4. Syntax to swap repetition values (A[1] = B[2])

   By Hoytopher, April 28, 2018
   • 1 reply
   • 674 views
   • 
   • Lee Smith
   • April 28, 2018

5. Days Since Last Race (record)

   By Poruchan, April 24, 2018   

   • date
   • last record
   • 1 reply
   • 1.7k views
   • 
   • Poruchan
   • April 25, 2018

6. Add Margin % or Selling Price in Stock Management

   By Kishan_Canoo, April 23, 2018   

   • fm12
   • 3 replies
   • 994 views
   • 
   • Lee Smith
   • April 25, 2018

7. Create Folder & Export Container Field In New Folde

   By Anuj Kumar, April 19, 2018   

   • fmp 16
   • export
   • (and 1 more)

      Tagged with:

     • fmp 16
     • export
     • create folder
   • 1 reply
   • 1.5k views
   • 
   • bcooney
   • April 22, 2018

8. Should I script this or can it be calculated

   By Rich, April 9, 2018
   • 10 replies
   • 1.5k views
   • 
   • siroos12
   • April 10, 2018

9. Newly created fields below current selection

   By Ninja, April 4, 2018
   • 4 replies
   • 762 views
   • 
   • Ninja
   • April 4, 2018

10. Field Calculation Recursion Help

    By CCBtx, March 24, 2018
    • 1 reply
    • 720 views
    • 
    • Fitch
    • March 26, 2018

11. Volume Calculations

    By Steve Martino, March 24, 2018
    • 0 replies
    • 704 views
    • 
    • Steve Martino
    • March 24, 2018

12. Calc to remove letter after space

    By Scott Hoffman, March 23, 2018
    • 2 replies
    • 743 views
    • 
    • Lee Smith
    • March 23, 2018

13. Date calculation in portal (remove ?)

    By ash1474, March 21, 2018   

    • getnthrecord
    • date
    • (and 2 more)

       Tagged with:

      • getnthrecord
      • date
      • calculation
      • portal
    • 9 replies
    • 1.9k views
    • 
    • ash1474
    • March 23, 2018

14. Sending Text Messages

    By Bikeman17, March 8, 2018
    • 2 replies
    • 1.9k views
    • 
    • Bikeman17
    • March 8, 2018

15. ValueCount with 2 criteria

    By Nick Drouet, May 12, 2010
    • 3 replies
    • 2.6k views
    • 
    • Lee Smith
    • March 7, 2018

16. Optimizing Slow Unstored Calculated Field Search and Export

    By brokenmouse, March 1, 2018   

    • unstored
    • calculated
    • (and 4 more)

       Tagged with:

      • unstored
      • calculated
      • search
      • export
      • optimization
      • help
    • 3 replies
    • 2k views
    • 
    • Fitch
    • March 2, 2018

17. Rounding up

    By shredded, February 27, 2018
    • 5 replies
    • 878 views
    • 
    • Fitch
    • March 2, 2018

18. Compare and Ranking calc

    By Ronnie Higgins, March 1, 2018   

    • ranking
    • compare
    • 0 replies
    • 740 views
    • 
    • Ronnie Higgins
    • March 1, 2018

19. It's been 4 days

    By randsome, February 13, 2018   

    • need help
    • 3 replies
    • 1k views
    • 
    • Fitch
    • February 14, 2018

20. DateTime Stamp

    By "... you mean these fans?", February 9, 2018
    • 4 replies
    • 956 views
    • 
    • "... you mean these fans?"
    • February 9, 2018

21. Calculate values on the layout

    By spand, February 5, 2018
    • 7 replies
    • 863 views
    • 
    • Fitch
    • February 6, 2018

22. Multiple related fields in a record from the same table

    By Hproth, February 4, 2018   

    • relationship
    • related records
    • (and 2 more)

       Tagged with:

      • relationship
      • related records
      • related fields
      • relationships
    • 3 replies
    • 1.1k views
    • 
    • Steve Martino
    • February 5, 2018

23. Enter pay period based on work dates

    By Lea Alexander, January 31, 2018
    • 2 replies
    • 906 views
    • 
    • Fitch
    • February 5, 2018

24. Help Parse Text Calculation

    By beckham, January 30, 2018   

    • calculation
    • 9 replies
    • 1.9k views
    • 
    • Lee Smith
    • January 31, 2018

25. Calculating percentages using summary fields

    By -dp-, January 30, 2018   

    • percent
    • summary
    • (and 1 more)

       Tagged with:

      • percent
      • summary
      • count
    • 6 replies
    • 2.2k views
    • 
    • -dp-
    • January 30, 2018

26. When is 5 not 5?

    By Chuck, January 24, 2018
    • 7 replies
    • 1.4k views
    • 
    • Chuck
    • January 25, 2018

27. ValueList Importing from one field to another

    By Ponderosa, January 23, 2018   

    • value list
    • set field
    • (and 4 more)

       Tagged with:

      • value list
      • set field
      • sorting
      • copy
      • paste
      • filter
    • 4 replies
    • 1.6k views
    • 
    • Lee Smith
    • January 24, 2018

28. Change Time Stamp to Date

    By kcep, January 16, 2018
    • 6 replies
    • 1.8k views
    • 
    • Lee Smith
    • January 17, 2018

29. difference between no index and recalculate

    By jimlongo, January 14, 2018
    • 3 replies
    • 1.4k views
    • 
    • Agnes Riley
    • January 15, 2018

30. Automating Date Lookups

    By Ponderosa, January 8, 2018   

    • calendar
    • date
    • (and 1 more)

       Tagged with:

      • calendar
      • date
      • lookup
    • 5 replies
    • 1.9k views
    • 
    • Ponderosa
    • January 9, 2018

31. Need to create a place to store a "source" for every field of data

    By bcooper, January 8, 2018
    • 11 replies
    • 1.1k views
    • 
    • Lee Smith
    • January 8, 2018

32. How to calculate a day in advance

    By Gilbert13, January 8, 2018
    • 4 replies
    • 1.2k views
    • 
    • Gilbert13
    • January 8, 2018

33. Move characters

    By OneStop, January 5, 2018
    • 2 replies
    • 1.1k views
    • 
    • LaRetta
    • January 6, 2018

34. Removing Characters Past X

    By OneStop, January 5, 2018
    • 2 replies
    • 866 views
    • 
    • OneStop
    • January 5, 2018

35. Years of Service Calculation

    By CKonash, September 26, 2017
    • 5 replies
    • 1.3k views
    • 
    • doughemi
    • December 31, 2017