Calculation Engine (Define Fields)

12,869 topics in this forum

1. Trouble with Month and MonthName functions

   By -dp-, February 1, 2019
   • 3 replies
   • 577 views
   • 
   • -dp-
   • February 2, 2019

2. Change capitalization

   By john9210, February 1, 2019
   • 2 replies
   • 526 views
   • 
   • comment
   • February 1, 2019

3. Crosstab Absence Sheet

   By Dimitrios Fkiaras, January 25, 2019   

   • Date Range
   • Repeating Calc
   • 12 replies
   • 1.3k views
   • 
   • LaRetta
   • January 30, 2019

4. Monthly Jump

   By Bikeman17, January 27, 2019
   • 4 replies
   • 608 views
   • 
   • Bikeman17
   • January 29, 2019

5. text calc displaying as zero

   By dysong3, January 14, 2019   

   • text calc
   • zero
   • 10 replies
   • 799 views
   • 
   • dysong3
   • January 15, 2019

6. Alphabetize values using List function

   By Rich S, January 13, 2019
   • 6 replies
   • 636 views
   • 
   • Rich
   • January 15, 2019

7. Transaction fee calculation

   By derlandson, January 13, 2019
   • 3 replies
   • 657 views
   • 
   • comment
   • January 13, 2019

8. "0" Zero

   By "... you mean these fans?", December 22, 2018
   • 19 replies
   • 985 views
   • 
   • Josh Ormond
   • January 3, 2019

9. Showing top 5 without bogging down the server

   By Matthew R White, December 11, 2018
   • 1 reply
   • 592 views
   • 
   • Fitch
   • December 15, 2018

10. Calculation field don't perform on new created record

    By ibobo, December 14, 2018
    • 5 replies
    • 658 views
    • 
    • comment
    • December 14, 2018

11. Tuesday dates

    By john9210, December 9, 2018
    • 2 replies
    • 622 views
    • 
    • john9210
    • December 10, 2018

12. Way to not count negatives?

    By Matthew R White, December 9, 2018
    • 1 reply
    • 679 views
    • 
    • bcooney
    • December 9, 2018

13. Sometimes my Calc field works, sometimes it doesn't

    By philipcaplan, December 6, 2018
    • 7 replies
    • 752 views
    • 
    • comment
    • December 6, 2018

14. Distinct count in sub-summary

    By Rich, December 3, 2018
    • 4 replies
    • 1.2k views
    • 
    • Rich
    • December 3, 2018

15. Speed and summary calculations

    By Matthew R White, November 30, 2018
    • 1 reply
    • 629 views
    • 
    • bcooney
    • December 1, 2018

16. Need help with calculation

    By stan111, November 27, 2018   

    • calculation
    • 15 replies
    • 932 views
    • 
    • stan111
    • November 30, 2018

17. A relationship, getting data with if statement between two fields choices

    By chuckcou, November 27, 2018
    • 3 replies
    • 619 views
    • 
    • comment
    • November 27, 2018

18. LAST NAME, FIRST NAME

    By MacFileman, November 20, 2018
    • 11 replies
    • 1.8k views
    • 
    • Chuck
    • November 27, 2018

19. Is there a GetNthRecord equivilent for portals

    By ddinisco, November 27, 2018
    • 1 reply
    • 675 views
    • 
    • comment
    • November 27, 2018

20. Calculate Shipping Costs - Updated

    By OneStop, November 20, 2018
    • 7 replies
    • 684 views
    • 
    • comment
    • November 20, 2018

21. Date calc error

    By JTSmith, November 14, 2018
    • 2 replies
    • 559 views
    • 
    • JTSmith
    • November 15, 2018

22. Parsing a compound name

    By john9210, November 15, 2018
    • 4 replies
    • 716 views
    • 
    • comment
    • November 15, 2018

23. Calculating days and time

    By Matthew R White, November 9, 2018
    • 1 reply
    • 579 views
    • 
    • comment
    • November 9, 2018

24. fmp17 PDF not viewing

    By Gismo12, October 31, 2018
    • 3 replies
    • 660 views
    • 
    • Steve Martino
    • November 5, 2018

25. Random Question

    By MacFileman, October 28, 2018
    • 10 replies
    • 606 views
    • 
    • OlgerDiekstra
    • October 30, 2018

26. Extracting Alphanumeric String from text field

    By dztrucktion, October 28, 2018
    • 7 replies
    • 1.9k views
    • 
    • dztrucktion
    • October 28, 2018

27. Same as an Excel dateif calc getting age

    By snekkis, October 26, 2018
    • 2 replies
    • 700 views
    • 
    • snekkis
    • October 26, 2018

28. Lookup Fields through relationships

    By OlgerDiekstra, October 18, 2018
    • 0 replies
    • 528 views
    • 
    • OlgerDiekstra
    • October 18, 2018

29. Help Pull the selected 2nd field values instead of 1st value

    By chadski021, October 13, 2018
    • 3 replies
    • 628 views
    • 
    • comment
    • October 14, 2018

30. Global Values not 'sticking'?

    By Wickerman, September 27, 2018
    • 15 replies
    • 751 views
    • 
    • comment
    • October 2, 2018

31. Help searching time on timestamplist

    By chadski021, September 25, 2018
    • 7 replies
    • 690 views
    • 
    • comment
    • September 25, 2018

32. Rebuilding an Index

    By Wickerman, September 12, 2018
    • 3 replies
    • 1.7k views
    • 
    • Wickerman
    • September 12, 2018

33. Validation to create a related record.

    By CKonash, September 9, 2018
    • 7 replies
    • 728 views
    • 
    • comment
    • September 12, 2018

34. Calculate to 1, 1st Invoice

    By "... you mean these fans?", September 8, 2018
    • 3 replies
    • 686 views
    • 
    • bcooney
    • September 8, 2018

35. Parsing multiple values into sub-records

    By Wickerman, September 7, 2018
    • 1 reply
    • 500 views
    • 
    • comment
    • September 7, 2018