Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Rounding question Post Reply Post New Topic
Author Message
ultraca
Newbie
Newbie
Avatar

Joined: 31 Mar 2011
Location: United States
Online Status: Offline
Posts: 23
Quote ultraca Replybullet Topic: Rounding question
    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}


IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 20 Jun 2011 at 9:05am
My suggestion is try converting all those fields to string with totext(commend) or something.

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.