Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with Year to Date and Month To Date Totals
I am having a problem with my year to date and month to date totals. What I am trying to do is calculate the totals for the YTD and MTD. I have set up a date range parameter as well allowing the user to select a beginning date and an ending date. The problem I have is in my record critera...- harley1d
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Formula for Trimming numeric fields
Using the following formula, How do I get this to only display the whole number if there is a "0" after the decimial point instead of a number? Example: if the formula return 18.5 this is ok but if it returns 18.0 I would like the 0 to be suppressed or trimmed. Sum ({@Transfer}) %...- harley1d
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Help Formatting a Percent formula
Can someone please help me with formatting this formula? The formula is working but I can't not format it to only return one decimal space. Currently it is retuning 12.54%. How do I get this to return 12.5%? I tried to convert the formula to a number to allow me to customize the number but...- harley1d
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
