Calculation Engine (Define Fields)

12,881 topics in this forum

1. Case / If Perhaps

   By Poruchan, October 15, 2015
   • 4 replies
   • 829 views
   • 
   • ggt667
   • October 15, 2015

2. Getting Case result from one record into preceding record

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

3. counting partial result

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

4. Finding Field Values in a one to many relationship

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

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

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

6. Round Function - Results seem incorrect

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

7. Dynamic Clock possible?

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

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

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

9. exporting data from a relational databases

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

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

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

11. seconds to minutes

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

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

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

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

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

14. How to display calculation correctly

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

15. Adding summary fields

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

16. Simple inventory database

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

17. Value lists in calculation fields

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

18. Let Function

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

19. Data Viewr Versus Calulated Field error

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

20. Running count of multiple checkbox selected products

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

21. Summarize field if another field equals a set parameter

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

22. Summary field sorting slow in related table

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

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

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

24. Sequentially enter 1 of 3 numbers?

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

25. Calc for performing find based on value list

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

26. Starting a new project

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

27. Counting with two specific values

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

28. Detecting only blank spaces in field

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

29. Counting fields with value in them

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

30. Percentage Values in Found Set

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

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

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

32. Evaluate()

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

33. Case function using Position function

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

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

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

35. Filter by length and case

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