Calculation Engine (Define Fields)

12,880 topics in this forum

1. Conditional formatting field based on another

   By skearton, December 15, 2016
   • 5 replies
   • 1.7k views
   • 
   • LaRetta
   • December 16, 2016

2. Tide tables

   By Greg Hains, December 13, 2016
   • 4 replies
   • 1.7k views
   • 
   • Greg Hains
   • December 15, 2016

3. Sum of different fields

   By Marinos Kangas, December 7, 2016
   • 5 replies
   • 1.5k views
   • 
   • Marinos Kangas
   • December 8, 2016

4. Checkbox sets and looping IF statements

   By dougroth, November 24, 2016
   • 6 replies
   • 3.2k views
   • 
   • Agnes Riley
   • December 7, 2016

5. Rounding a summary field

   By enquirerfm, May 10, 2010
   • 7 replies
   • 4.6k views
   • 
   • Steve Martino
   • December 6, 2016

6. Calculation of Vacation allowed

   By karenjoy, December 5, 2016
   • 5 replies
   • 1.1k views
   • 
   • karenjoy
   • December 6, 2016

7. Extracting Data via Calculation

   By beckham, November 30, 2016
   • 2 replies
   • 856 views
   • 
   • beckham
   • November 30, 2016

8. Parse and Trim in One Calculation

   By steigrafx, November 27, 2016
   • 2 replies
   • 931 views
   • 
   • steigrafx
   • November 27, 2016

9. Delete the field contents before the ocurrence of any two letters

   By Dr. Zathras, November 23, 2016
   • 2 replies
   • 994 views
   • 
   • Dr. Zathras
   • November 23, 2016

10. Date range within a calculation

    By davidnickerson, November 18, 2016
    • 13 replies
    • 3.9k views
    • 
    • davidnickerson
    • November 19, 2016

11. take just the last 2 characters

    By fileman922, November 18, 2016
    • 2 replies
    • 832 views
    • 
    • fileman922
    • November 19, 2016

12. Hebrew Calender converter

    By Smiley, November 2, 2016
    • 7 replies
    • 1.9k views
    • 
    • Smiley
    • November 16, 2016

13. Highlight top 3 values

    By liltbrockie, November 16, 2016
    • 2 replies
    • 988 views
    • 
    • comment
    • November 16, 2016

14. Export field contents into external file

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

15. Import loads of data using show custom dialog

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

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

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

17. Record Overlap

    By MacFileman, November 13, 2016
    • 5 replies
    • 1.1k views
    • 
    • MacFileman
    • November 14, 2016

18. unstored calculations inventory performance

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

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

    By Kishan_Canoo, November 4, 2016
    • 2 replies
    • 1.6k views
    • 
    • Kishan_Canoo
    • November 9, 2016

20. Subtract Percentages

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

21. GetNthRecord calculation changes based on sort order

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

22. Find the week before calculation

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

23. Multi-Series Google Bar Charts

    By brendan_mahe, November 1, 2016
    • 3 replies
    • 2.9k views
    • 
    • brendan_mahe
    • November 3, 2016

24. Variable increments in self-joining relationship calculation?

    By steveald, August 19, 2016
    • 24 replies
    • 2.3k views
    • 
    • comment
    • October 27, 2016

25. FilePath calculation / FMServer

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

26. Triggering a script when opening window

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

27. Stupid question calculation

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

28. Parsing text Data from Field

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

29. Year (TABLE::DATE) partially working

    By fm8443, October 14, 2016
    • 5 replies
    • 1.4k views
    • 
    • fm8443
    • October 15, 2016

30. TRUE ≠ 1 and odd behaviour after import

    By Joost Miltenburg, October 13, 2016
    • 0 replies
    • 923 views
    • 
    • Joost Miltenburg
    • October 13, 2016

31. Weekly and monthly Calculation

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

32. Text Parsing multiple times into one field

    By Oyseka, October 8, 2016
    • 6 replies
    • 1.2k views
    • 
    • Oyseka
    • October 9, 2016

33. Calculation - Customer loyalty

    By Kishan_Canoo, October 8, 2016
    • 5 replies
    • 1.4k views
    • 
    • Kishan_Canoo
    • October 8, 2016

34. CASE ERROR

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

35. DATE CALCULATION

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