Calculation Engine (Define Fields)

12,867 topics in this forum

1. Export field contents into external file

   By Toni, November 11, 2016
   • 11 replies
   • 1.1k views
   • 
   • webko
   • November 15, 2016

2. Import loads of data using show custom dialog

   By snow23, November 14, 2016
   • 1 reply
   • 708 views
   • 
   • comment
   • November 14, 2016

3. If the field CONTAINS text value of "blah blah"

   By chikanyc, July 22, 2009
   • 3 replies
   • 36k views
   • 
   • The Crow
   • November 14, 2016

4. Record Overlap

   By MacFileman, November 13, 2016
   • 5 replies
   • 937 views
   • 
   • MacFileman
   • November 14, 2016

5. unstored calculations inventory performance

   By fileman922, November 10, 2016
   • 2 replies
   • 1.1k views
   • 
   • Wim Decorte
   • November 10, 2016

6. ‘Item Movement’ (e.g. Best-seller, Fast, slow)

   By Kishan_Canoo, November 4, 2016   

   • fmp12
   • 2 replies
   • 1.3k views
   • 
   • Kishan_Canoo
   • November 9, 2016

7. Subtract Percentages

   By OneStop, November 7, 2016
   • 7 replies
   • 1.7k views
   • 
   • OneStop
   • November 8, 2016

8. GetNthRecord calculation changes based on sort order

   By Ziphius, November 4, 2016
   • 4 replies
   • 876 views
   • 
   • Ziphius
   • November 7, 2016

9. Find the week before calculation

   By RyanESmith7, October 19, 2016
   • 6 replies
   • 906 views
   • 
   • RyanESmith7
   • November 4, 2016

10. Multi-Series Google Bar Charts

    By brendan_mahe, November 1, 2016   

    • google charts
    • executesql
    • 3 replies
    • 2.6k views
    • 
    • brendan_mahe
    • November 3, 2016

11. Variable increments in self-joining relationship calculation?

    By steveald, August 19, 2016   

    • pop up menu
    • self-joining relationship
    • 24 replies
    • 1.9k views
    • 
    • comment
    • October 27, 2016

12. FilePath calculation / FMServer

    By balooka, October 27, 2016
    • 6 replies
    • 1k views
    • 
    • comment
    • October 27, 2016

13. Triggering a script when opening window

    By uthealth, October 25, 2016
    • 3 replies
    • 814 views
    • 
    • Fitch
    • October 27, 2016

14. Stupid question calculation

    By Nousstars, October 25, 2016
    • 2 replies
    • 648 views
    • 
    • Nousstars
    • October 26, 2016

15. Parsing text Data from Field

    By Ron Neville, October 24, 2016
    • 2 replies
    • 745 views
    • 
    • Ron Neville
    • October 24, 2016

16. Year (TABLE::DATE) partially working

    By fm8443, October 14, 2016   

    • calculation
    • 5 replies
    • 1.1k views
    • 
    • fm8443
    • October 15, 2016

17. TRUE ≠ 1 and odd behaviour after import

    By Joost Miltenburg, October 13, 2016   

    • boolean
    • true
    • 0 replies
    • 780 views
    • 
    • Joost Miltenburg
    • October 13, 2016

18. Weekly and monthly Calculation

    By Ron Neville, October 12, 2016
    • 2 replies
    • 890 views
    • 
    • LaRetta
    • October 12, 2016

19. Text Parsing multiple times into one field

    By Oyseka, October 8, 2016   

    • text
    • parsing
    • (and 1 more)

       Tagged with:

      • text
      • parsing
      • insertcalculatedresult
    • 6 replies
    • 1k views
    • 
    • Oyseka
    • October 9, 2016

20. Calculation - Customer loyalty

    By Kishan_Canoo, October 8, 2016   

    • fmp12
    • 5 replies
    • 1.1k views
    • 
    • Kishan_Canoo
    • October 8, 2016

21. CASE ERROR

    By Dr.Gopala krishnam raju AMBATI, October 8, 2016
    • 6 replies
    • 1.2k views
    • 
    • Dr.Gopala krishnam raju AMBATI
    • October 8, 2016

22. DATE CALCULATION

    By rem, October 4, 2016
    • 1 reply
    • 693 views
    • 
    • comment
    • October 4, 2016

23. Fiscal Year Question February 1 - January 31st

    By Nestor, October 3, 2016   

    • functions
    • fiscal year
    • (and 1 more)

       Tagged with:

      • functions
      • fiscal year
      • pc
    • 9 replies
    • 3.3k views
    • 
    • comment
    • October 3, 2016

24. Get(Device) Help

    By Nathan Wilcox, September 30, 2016
    • 2 replies
    • 896 views
    • 
    • Nathan Wilcox
    • September 30, 2016

25. Trouble with tax rates based on invoice total

    By tbcomputerguy, September 27, 2016
    • 1 reply
    • 710 views
    • 
    • comment
    • September 27, 2016

26. Current stock quantity

    By sal88, July 19, 2016   

    • inventory
    • quantity
    • 17 replies
    • 3.3k views
    • 
    • sal88
    • September 26, 2016

27. Count

    By AlvaroPIon, September 22, 2016
    • 13 replies
    • 1.8k views
    • 
    • Alvaro Pion
    • September 26, 2016

28. Counting values across different fields

    By sinisa93, September 9, 2016
    • 6 replies
    • 946 views
    • 
    • sinisa93
    • September 19, 2016

29. Parsing Negative Values

    By "... you mean these fans?", September 18, 2016
    • 2 replies
    • 788 views
    • 
    • "... you mean these fans?"
    • September 18, 2016

30. Get Current Time as HH:mm:ssZ

    By Devin, September 15, 2016
    • 6 replies
    • 1.5k views
    • 
    • comment
    • September 15, 2016

31. How to not increment a field with an auto enter increment

    By Oyseka, September 14, 2016   

    • calculation
    • duplicate records
    • (and 1 more)

       Tagged with:

      • calculation
      • duplicate records
      • fixedid
    • 0 replies
    • 885 views
    • 
    • Oyseka
    • September 14, 2016

32. Multiple values in a single field, how to get the highest

    By aharown07, September 10, 2016   

    • max
    • 2 replies
    • 846 views
    • 
    • aharown07
    • September 10, 2016

33. Calc combined list of two fields

    By shredded, September 8, 2016
    • 12 replies
    • 1.4k views
    • 
    • comment
    • September 9, 2016

34. Creating total summary field from related records

    By muskee, September 6, 2016
    • 3 replies
    • 784 views
    • 
    • comment
    • September 7, 2016

35. Auto-completion field with input of two fields

    By Dr.Hamed, September 6, 2016   

    • autocompletion
    • 1 reply
    • 649 views
    • 
    • Agnes Riley
    • September 6, 2016