Calculation Engine (Define Fields)

12,880 topics in this forum

1. Getting Case result from one record into preceding record

   By Poruchan, October 8, 2015
   • 4 replies
   • 1.6k views
   • 
   • Poruchan
   • October 15, 2015

2. counting partial result

   By Marcus69, October 10, 2015
   • 10 replies
   • 1.9k views
   • 
   • Marcus69
   • October 14, 2015

3. Finding Field Values in a one to many relationship

   By andersonk06, October 9, 2015
   • 7 replies
   • 1.4k views
   • 
   • andersonk06
   • October 12, 2015

4. How do you get previous Invoice's total/

   By justinkim943, October 12, 2015
   • 1 reply
   • 867 views
   • 
   • eos
   • October 12, 2015

5. Round Function - Results seem incorrect

   By djlane, October 12, 2015
   • 2 replies
   • 970 views
   • 
   • djlane
   • October 12, 2015

6. Dynamic Clock possible?

   By Mikhail, October 3, 2015
   • 7 replies
   • 1.2k views
   • 
   • ggt667
   • October 8, 2015

7. Mixing manual entry fields and calculation fields in List view

   By laguna92651, October 7, 2015
   • 4 replies
   • 842 views
   • 
   • laguna92651
   • October 8, 2015

8. exporting data from a relational databases

   By msoussi, October 7, 2015
   • 8 replies
   • 834 views
   • 
   • Lee Smith
   • October 7, 2015

9. Extract account name in front of the "@" sign in an e-mail addy

   By Rich S, October 6, 2015
   • 5 replies
   • 878 views
   • 
   • comment
   • October 7, 2015

10. seconds to minutes

    By Poruchan, October 5, 2015
    • 9 replies
    • 3k views
    • 
    • Poruchan
    • October 5, 2015

11. Space in a field is not a null return?

    By John Chamberlain, October 3, 2015
    • 1 reply
    • 909 views
    • 
    • comment
    • October 3, 2015

12. Format text no matter what is entered into the field

    By Matthew R White, October 1, 2015
    • 4 replies
    • 2.5k views
    • 
    • bcooney
    • October 1, 2015

13. How to display calculation correctly

    By loscamos, September 21, 2015
    • 17 replies
    • 1.6k views
    • 
    • dwdata
    • September 30, 2015

14. Adding summary fields

    By Snorkell, September 30, 2015
    • 0 replies
    • 610 views
    • 
    • Snorkell
    • September 30, 2015

15. Simple inventory database

    By confusedmuch, September 26, 2015
    • 6 replies
    • 3.5k views
    • 
    • comment
    • September 29, 2015

16. Value lists in calculation fields

    By Phillip Prahl, September 24, 2015
    • 3 replies
    • 762 views
    • 
    • comment
    • September 26, 2015

17. Let Function

    By aguest, September 25, 2015
    • 2 replies
    • 961 views
    • 
    • Lee Smith
    • September 25, 2015

18. Data Viewr Versus Calulated Field error

    By dkey, September 2, 2015
    • 12 replies
    • 1.2k views
    • 
    • Lee Smith
    • September 21, 2015

19. Running count of multiple checkbox selected products

    By FMData12, September 18, 2015
    • 2 replies
    • 1.8k views
    • 
    • FMData12
    • September 21, 2015

20. Summarize field if another field equals a set parameter

    By Matthew R White, September 18, 2015
    • 2 replies
    • 689 views
    • 
    • comment
    • September 19, 2015

21. Summary field sorting slow in related table

    By ACT, September 18, 2015
    • 0 replies
    • 658 views
    • 
    • ACT
    • September 18, 2015

22. Extracting string of text from one field with different variables

    By jl2017, September 16, 2015
    • 7 replies
    • 1.4k views
    • 
    • comment
    • September 16, 2015

23. Sequentially enter 1 of 3 numbers?

    By Matthew R White, August 20, 2015
    • 16 replies
    • 1.2k views
    • 
    • comment
    • September 15, 2015

24. Calc for performing find based on value list

    By Steve Martino, September 12, 2015
    • 4 replies
    • 721 views
    • 
    • Steve Martino
    • September 14, 2015

25. Starting a new project

    By genious, September 12, 2015
    • 0 replies
    • 725 views
    • 
    • genious
    • September 12, 2015

26. Counting with two specific values

    By madman411, September 11, 2015
    • 3 replies
    • 783 views
    • 
    • madman411
    • September 12, 2015

27. Detecting only blank spaces in field

    By McScripta, September 11, 2015
    • 4 replies
    • 1.3k views
    • 
    • McScripta
    • September 11, 2015

28. Counting fields with value in them

    By McScripta, September 11, 2015
    • 3 replies
    • 873 views
    • 
    • comment
    • September 11, 2015

29. Percentage Values in Found Set

    By Chuck, September 11, 2015
    • 2 replies
    • 681 views
    • 
    • comment
    • September 11, 2015

30. Copy All Records in One Table to a Dummy Table

    By bleapy, September 9, 2015
    • 7 replies
    • 3.3k views
    • 
    • bleapy
    • September 10, 2015

31. Evaluate()

    By bleapy, September 3, 2015
    • 8 replies
    • 1.2k views
    • 
    • bleapy
    • September 9, 2015

32. Case function using Position function

    By Stu412, September 8, 2015
    • 13 replies
    • 1.9k views
    • 
    • Wim Decorte
    • September 9, 2015

33. Better way to CrossTab than FM Advanced training book?

    By Stu412, September 9, 2015
    • 1 reply
    • 1.3k views
    • 
    • Kris M
    • September 9, 2015

34. Filter by length and case

    By sal88, August 31, 2015
    • 6 replies
    • 867 views
    • 
    • sal88
    • September 4, 2015

35. Sub Query within ExecuteSQL

    By aguest, September 3, 2015
    • 3 replies
    • 4k views
    • 
    • eos
    • September 3, 2015