Calculation Engine (Define Fields)

12,869 topics in this forum

1. Maintaining number format during calculations

   By Matt Malyschko, October 16, 2012
   • 5 replies
   • 981 views
   • 
   • Matt Malyschko
   • October 21, 2012

2. Help with calculation in FM 5.5v11

   By DLM, October 18, 2012
   • 6 replies
   • 751 views
   • 
   • DLM
   • October 19, 2012

3. Filter list calculation based on 2nd repetition value not being empty

   By 4Justme2, October 18, 2012
   • 4 replies
   • 804 views
   • 
   • comment
   • October 19, 2012

4. Age at the time of a specific event (that does not recalculate)

   By 4Justme2, September 7, 2012
   • 13 replies
   • 939 views
   • 
   • LaRetta
   • October 18, 2012

5. Shorten a Long Title...

   By Dr. Evil, October 18, 2012
   • 6 replies
   • 845 views
   • 
   • Dr. Evil
   • October 18, 2012

6. Deadline Label via Current Date State

   By Dr. Evil, October 15, 2012
   • 4 replies
   • 764 views
   • 
   • Dr. Evil
   • October 16, 2012

7. Need a calc to have different-colored first letter of a company name

   By Rich S, October 15, 2012
   • 2 replies
   • 521 views
   • 
   • Rich S
   • October 15, 2012

8. Adding total from the same field with different numbers

   By TaiChi56, October 9, 2012
   • 7 replies
   • 741 views
   • 
   • TaiChi56
   • October 14, 2012

9. Month over month Summary report

   By jtwilber, October 10, 2012
   • 5 replies
   • 987 views
   • 
   • jtwilber
   • October 11, 2012

10. Average (variable) value between two changing date ranges

    By 4Justme2, October 3, 2012
    • 9 replies
    • 1.5k views
    • 
    • 4Justme2
    • October 11, 2012

11. Career database: years, months and days between promotions

    By central11, October 9, 2012
    • 4 replies
    • 1.1k views
    • 
    • doughemi
    • October 10, 2012

12. Calculate using subtraction

    By TaiChi56, October 6, 2012
    • 3 replies
    • 735 views
    • 
    • TaiChi56
    • October 6, 2012

13. Limiting Results with the 'List' function?

    By MariaAux, October 4, 2012
    • 5 replies
    • 807 views
    • 
    • comment
    • October 5, 2012

14. Combine multiple fields into one, but ignoring blanks

    By Bmiller4evr, October 3, 2012
    • 6 replies
    • 2.9k views
    • 
    • LaRetta
    • October 5, 2012

15. Number of days in old Financial year and in new financial year

    By bittan, October 2, 2012
    • 12 replies
    • 1.9k views
    • 
    • comment
    • October 4, 2012

16. NULL value

    By Matt Malyschko, October 3, 2012
    • 2 replies
    • 629 views
    • 
    • Matt Malyschko
    • October 3, 2012

17. Half my fields showing question marks

    By Ziphius, October 1, 2012
    • 1 reply
    • 884 views
    • 
    • Ziphius
    • October 2, 2012

18. Patterncount problem

    By johnrh, August 9, 2012
    • 7 replies
    • 1.7k views
    • 
    • johnrh
    • October 1, 2012

19. Assistance with 2 calculations

    By Skiffy, September 28, 2012
    • 4 replies
    • 930 views
    • 
    • Skiffy
    • October 1, 2012

20. Pull data from last years record?

    By Matthew R White, October 1, 2012
    • 2 replies
    • 506 views
    • 
    • doughemi
    • October 1, 2012

21. Sum specific fields

    By Reid, October 1, 2012
    • 5 replies
    • 707 views
    • 
    • comment
    • October 1, 2012

22. Best way to deal with SSN

    By James Gill, September 28, 2012
    • 2 replies
    • 790 views
    • 
    • Lee Smith
    • September 28, 2012

23. How to test container field for "sound" file?

    By K1200, September 27, 2012
    • 3 replies
    • 698 views
    • 
    • comment
    • September 28, 2012

24. Calculation to compare field contents

    By Bmiller4evr, September 25, 2012
    • 8 replies
    • 937 views
    • 
    • comment
    • September 28, 2012

25. How to disable the "Sound Record" function?

    By K1200, September 27, 2012
    • 2 replies
    • 739 views
    • 
    • K1200
    • September 28, 2012

26. Subtracting from balance

    By lesterd, September 25, 2012
    • 3 replies
    • 818 views
    • 
    • lesterd
    • September 27, 2012

27. Simply If Statement Not Working

    By dschaal, August 29, 2012
    • 8 replies
    • 1k views
    • 
    • dschaal
    • September 26, 2012

28. LeftWords...RightWords...MiddleWords, how about an AnyWords?

    By Bmiller4evr, September 25, 2012
    • 4 replies
    • 837 views
    • 
    • Ocean West
    • September 26, 2012

29. Logging in via Web Publishing or Local Host?

    By MariaAux, September 24, 2012
    • 5 replies
    • 1.1k views
    • 
    • MariaAux
    • September 25, 2012

30. Counting duplicated dates only once by customer

    By Enigma20xx, September 25, 2012
    • 2 replies
    • 562 views
    • 
    • Enigma20xx
    • September 25, 2012

31. Summary by every line in a list

    By tijnisfijn, September 25, 2012
    • 0 replies
    • 592 views
    • 
    • tijnisfijn
    • September 25, 2012

32. Getting the Contents of one field into another

    By FileMakerHarry, September 19, 2012
    • 4 replies
    • 1k views
    • 
    • FileMakerHarry
    • September 25, 2012

33. Text field for keywords

    By Miron, September 21, 2012
    • 12 replies
    • 1.6k views
    • 
    • Miron
    • September 23, 2012

34. Multiplying Summary Field

    By FileMakerHarry, September 18, 2012
    • 6 replies
    • 1.4k views
    • 
    • comment
    • September 20, 2012

35. Conditional formatting across two records?

    By MariaAux, September 18, 2012
    • 2 replies
    • 583 views
    • 
    • MariaAux
    • September 19, 2012