Calculation Engine (Define Fields)

12,880 topics in this forum

1. Conditional Sum with multiple tests

   By wzzly, July 16, 2012
   • 2 replies
   • 729 views
   • 
   • wzzly
   • July 17, 2012

2. calculation between various conditions

   By Ben Ball, July 16, 2012
   • 2 replies
   • 729 views
   • 
   • Ben Ball
   • July 16, 2012

3. Refresh calculated fields

   By bellinat0r, July 15, 2012
   • 1 reply
   • 994 views
   • 
   • eos
   • July 15, 2012

4. What's that Function to get a List of values...

   By Wickerman, July 9, 2012
   • 8 replies
   • 1.4k views
   • 
   • Wickerman
   • July 10, 2012

5. Look Up vs. Calculation vs. GetField -- Pros and Cons

   By geraldh, July 6, 2012
   • 8 replies
   • 15.9k views
   • 
   • Rick Whitelaw
   • July 10, 2012

6. How to calculate monthly rent (not simple)

   By JTSmith, July 6, 2012
   • 6 replies
   • 1.6k views
   • 
   • JTSmith
   • July 10, 2012

7. Help setting up a calculation fields for a report

   By flutegirl, June 29, 2012
   • 5 replies
   • 1.4k views
   • 
   • comment
   • July 9, 2012

8. Creating an estimate number based on the client/event

   By geraldh, July 6, 2012
   • 2 replies
   • 684 views
   • 
   • geraldh
   • July 9, 2012

9. Calc Field To Generate List Of Dates

   By Ron Cates, July 5, 2012
   • 12 replies
   • 1.8k views
   • 
   • Ron Cates
   • July 7, 2012

10. GetAsNumber()

    By adyf, July 5, 2012
    • 5 replies
    • 1.3k views
    • 
    • comment
    • July 6, 2012

11. Case Statement - only last statement not working

    By dschaal, June 25, 2012
    • 11 replies
    • 1.8k views
    • 
    • dschaal
    • July 5, 2012

12. Calculating sums for a found set in a related table

    By AnotherNewGuy, July 5, 2012
    • 0 replies
    • 662 views
    • 
    • AnotherNewGuy
    • July 5, 2012

13. Grabbing first ever related record if within a date range..

    By DanMarks, July 4, 2012
    • 2 replies
    • 1.2k views
    • 
    • doughemi
    • July 4, 2012

14. Question on adding default value in a calulation unless field says different

    By stevebull, June 28, 2012
    • 4 replies
    • 969 views
    • 
    • comment
    • July 3, 2012

15. Calculation Bug?

    By Don_Macaroni, July 1, 2012
    • 2 replies
    • 842 views
    • 
    • Agnes Riley
    • July 2, 2012

16. Carriage Return Issues

    By tchemiy, June 28, 2012
    • 4 replies
    • 1.1k views
    • 
    • tchemiy
    • July 2, 2012

17. connecting tables?

    By marys26, July 2, 2012
    • 2 replies
    • 713 views
    • 
    • marys26
    • July 2, 2012

18. Year(Get(CurrentDate) ?

    By Michelle Logan, July 2, 2012
    • 4 replies
    • 956 views
    • 
    • comment
    • July 2, 2012

19. Portal row - sum specific records only

    By 4Justme2, June 21, 2012
    • 6 replies
    • 1.7k views
    • 
    • No_access
    • June 30, 2012

20. lookup parent, grandparent, or great-grandparent?

    By LaRetta, June 29, 2012
    • 1 reply
    • 869 views
    • 
    • LaRetta
    • June 29, 2012

21. All process welded dates

    By The Big Bear, June 26, 2012
    • 4 replies
    • 1.2k views
    • 
    • The Big Bear
    • June 29, 2012

22. Number limit of Else If statements

    By Michelle Logan, June 28, 2012
    • 5 replies
    • 1.7k views
    • 
    • Fitch
    • June 29, 2012

23. SImple arithmetical error

    By jdjd, June 26, 2012
    • 5 replies
    • 1.1k views
    • 
    • comment
    • June 28, 2012

24. Need GetNthRecord-style function for RecordIDs

    By K1200, June 24, 2012
    • 4 replies
    • 1.1k views
    • 
    • comment
    • June 28, 2012

25. Calculating Week Number of Month

    By Joe_Schmo, June 27, 2012
    • 2 replies
    • 914 views
    • 
    • Joe_Schmo
    • June 27, 2012

26. Can someone explain how images are handled in FMP 12?

    By nleon307, June 26, 2012
    • 1 reply
    • 1.2k views
    • 
    • Lee Smith
    • June 26, 2012

27. Parsing data from a single field into multiple fields?

    By HALBURN, June 23, 2012
    • 5 replies
    • 762 views
    • 
    • Vaughan
    • June 26, 2012

28. Store files in containers? Or Reference?

    By JTSmith, June 26, 2012
    • 1 reply
    • 672 views
    • 
    • Aussie John
    • June 26, 2012

29. Struggling with easy text parsing...

    By JTSmith, June 22, 2012
    • 4 replies
    • 816 views
    • 
    • JTSmith
    • June 22, 2012

30. Validate the field based on the another field

    By Muralidharan, June 22, 2012
    • 2 replies
    • 960 views
    • 
    • comment
    • June 22, 2012

31. Calendar Validation

    By 4Justme2, June 20, 2012
    • 7 replies
    • 956 views
    • 
    • 4Justme2
    • June 20, 2012

32. Calculation to show oldest and newest creation date?

    By Fredrik, June 12, 2012
    • 9 replies
    • 1.2k views
    • 
    • LaRetta
    • June 19, 2012

33. recurring calendar event

    By Chemadian, June 1, 2012
    • 6 replies
    • 3.2k views
    • 
    • eos
    • June 16, 2012

34. Goto Script help

    By cterrell16, June 15, 2012
    • 2 replies
    • 736 views
    • 
    • Fitch
    • June 15, 2012

35. Text Parsing Question

    By JTSmith, June 15, 2012
    • 2 replies
    • 874 views
    • 
    • JTSmith
    • June 15, 2012