Rounding question
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13550
Printed Date: 29 Apr 2024 at 12:35am
Topic: Rounding question
Posted By: ultraca
Subject: Rounding question
Date Posted: 20 Jun 2011 at 8:37am
I'm having issues with rounding results of a formula I created. Its a
simple formula and I've tried "Format Field" and adjusting the number
Style as well as the rounding options in the Customize section but to no
avail. My decimal places only show zeros.
What the heck am I missing? My results column is just the 06/2011 column multiplied by the Average Column
Formula 1 = Ticket count = 06/2011
if DateDiff ("m", {Close Date}, CurrentDateTime) in 0 to 1 then 1
Formula 2 = AVG = Average
Average ({@Date Diff Open/Closed},{srv_desc.sym})
Formula 3 = Results
Sum ({@Ticket count},{srv_desc.sym}) * {@AVG}
|
Replies:
Posted By: kostya1122
Date Posted: 20 Jun 2011 at 9:05am
My suggestion is try converting all those fields to string with totext(commend) or something.
|
|