Calculation Engine (Define Fields)

12,872 topics in this forum

1. Exclude weekends from number of days between dates?

   By Matt Klein, August 15, 2012
   • 3 replies
   • 2.8k views
   • 
   • finaquant
   • August 20, 2012

2. Using GetField with a repeating field?

   By BriSchnei, July 14, 2012
   • 4 replies
   • 1.6k views
   • 
   • Peter Bouma
   • August 14, 2012

3. newbie date range calculations

   By 3mjh, August 1, 2012
   • 3 replies
   • 886 views
   • 
   • Peter Bouma
   • August 13, 2012

4. Get Field Name

   By "... you mean these fans?", August 10, 2012
   • 16 replies
   • 7.1k views
   • 
   • comment
   • August 13, 2012

5. How do I capture the last user?

   By keelbolt, August 13, 2012
   • 1 reply
   • 579 views
   • 
   • bcooney
   • August 13, 2012

6. Get last row from related portal

   By Dani Rubenstein, August 12, 2012
   • 5 replies
   • 1.1k views
   • 
   • Dani Rubenstein
   • August 13, 2012

7. Struggling with calculating total spent by customer...

   By JTSmith, August 13, 2012
   • 1 reply
   • 583 views
   • 
   • JTSmith
   • August 13, 2012

8. fmp12 summary glitch

   By rivet, July 24, 2012
   • 5 replies
   • 1.2k views
   • 
   • billw
   • August 12, 2012

9. How to "Get ( TableName )" for each table

   By dmontano, June 4, 2010
   • 8 replies
   • 11.1k views
   • 
   • dansmith65
   • August 10, 2012

10. Modifying existing calc

    By David Nelson, August 8, 2012
    • 6 replies
    • 942 views
    • 
    • comment
    • August 9, 2012

11. Adding Leading and Trailing Zeros to an Entered Number

    By Stuppy, August 3, 2012
    • 6 replies
    • 6.5k views
    • 
    • comment
    • August 4, 2012

12. display changing records in a static layout without interfering with a web viewer

    By hartmut, August 1, 2012
    • 8 replies
    • 968 views
    • 
    • hartmut
    • August 3, 2012

13. Problems with GetField from a multi-criteria related table

    By benchwrm11, July 27, 2012
    • 4 replies
    • 868 views
    • 
    • benchwrm11
    • August 3, 2012

14. Stores and in/out

    By alex005, July 10, 2012
    • 5 replies
    • 1.2k views
    • 
    • Lee Smith
    • August 1, 2012

15. How do I parse using the day as a sufix

    By Kiele, July 31, 2012
    • 13 replies
    • 1.7k views
    • 
    • Kiele
    • August 1, 2012

16. So simple - but doesn't work!

    By ibcarolek, July 29, 2012
    • 2 replies
    • 875 views
    • 
    • fmhappyguy
    • July 29, 2012

17. Calculating remaining inventory on X date based on items already reserved

    By Joe_Schmo, July 24, 2012
    • 24 replies
    • 4.7k views
    • 
    • eos
    • July 28, 2012

18. Problems with Calculation and Nested IF instruction based on a Checkbox

    By n7mafia, July 25, 2012
    • 12 replies
    • 1.3k views
    • 
    • Lee Smith
    • July 28, 2012

19. Serial Number as a Date

    By nixdorf, July 26, 2012
    • 6 replies
    • 939 views
    • 
    • comment
    • July 27, 2012

20. Setting a field value for all records from a global sort of value

    By bac mac, July 23, 2012
    • 9 replies
    • 1.6k views
    • 
    • bac mac
    • July 26, 2012

21. using a total calculation in a filtered portal in a calculation

    By fiunary, July 24, 2012
    • 1 reply
    • 703 views
    • 
    • fiunary
    • July 24, 2012

22. posting dates on one line

    By The Big Bear, July 16, 2012
    • 6 replies
    • 1.3k views
    • 
    • The Big Bear
    • July 23, 2012

23. Sum top 3 rows in a portal

    By ElderBrE, July 22, 2012
    • 7 replies
    • 1.3k views
    • 
    • ElderBrE
    • July 22, 2012

24. Remove extra characters

    By David Nelson, July 18, 2012
    • 4 replies
    • 1.1k views
    • 
    • David Nelson
    • July 20, 2012

25. Calculation vs Summary : Are there any advantages/disadvantages

    By geraldh, July 19, 2012
    • 2 replies
    • 720 views
    • 
    • geraldh
    • July 19, 2012

26. calc to change layout when web viewer url changes to a specific address

    By hartmut, July 17, 2012
    • 3 replies
    • 902 views
    • 
    • No_access
    • July 19, 2012

27. Populating field repetitions with list values

    By Rewolfer, July 6, 2012
    • 25 replies
    • 7.8k views
    • 
    • comment
    • July 18, 2012

28. Conditional Sum with multiple tests

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

29. calculation between various conditions

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

30. Refresh calculated fields

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

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

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

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

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

33. How to calculate monthly rent (not simple)

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

34. Help setting up a calculation fields for a report

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

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

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