INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Common Formulas

Common formula examples by kenhamady
Posted: 7 Oct 00 (Edited 19 Jul 08)

The following link has formulas that show how to do many commonly requested tasks:

http://www.kenhamady.com/formula.html

The current formulas include:

1. The number of "Work Days" between any two dates:
2. Converting a Numeric Date to True Date:
3. Converting a Character Date to True Date:
4. Use a parameter prompt to select the Sort/Group order, using fields of mixed data types:
5. Adding a month or months to a date:
6. Calculating an accurate Age Integer from a Date of Birth:
7. Printing Parameter Selections for Multiple or Range Values:
8. Making Multiple Variable Assignments in One Formula:
9. Converting total seconds to a formatted "elapsed time" string:
10. Conditional Total using an If-Then-Else formula:
11. Conditional Total using a Running Total:
12. Manual Cross-Tabs (Cross-Tabs that allow formulas):
13. The number of Business Hours between DateTime Values.
14. Distinct Count of an If-Then-Else Formula.
15. Convert Decimal Numbers to Text, showing only the Non-Zero Decimal Places.
16. Append a List of Detail Strings into one Line.
17. Adding a Number of Business Days to a Date
18. How to Print "Continued on Next Page"
19. Finding the Last Friday of the Month
20. Removing the Path from the "File Path and Name" field
21. Find Monday of a specific week (using ISO standard week numbers)
22. Rounding to the nearest nickel, or other odd increment
23. Finding the First Friday of the Month
24. Finding the Number of Fridays in a Date Range
25. How to find Good Friday (or Easter) for any year
26. How to Generate a list of Common Holidays for any Year


Ken Hamady, On-site Crystal Reports training & consulting
Public classes and individual training.
Expert's Guide to Formulas in Crystal Reports
http://www.kenhamady.com/

Back to Business Objects: Crystal Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close