Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) [Solved] My totals are off by a penny (Read 1951 times)
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] My totals are off by a penny
Reply #15 - Oct 2nd, 2007 at 4:13pm
Print Post Print Post  
I tried both the original code and the modified code. The only change would have been a lack of decimal places as the result would have been an Int and not a Money so it would not have had decimal places.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] My totals are off by a penny
Reply #16 - Oct 2nd, 2007 at 7:49pm
Print Post Print Post  
Well, I dunno what happened the first time I tried it, but it's working fine now, so thanks again.

While I was working on this, I changed the programming that calculates the grand total so that it includes an @Round statement as well.  Is this overkill?  Should I take it out?
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] My totals are off by a penny
Reply #17 - Oct 2nd, 2007 at 8:44pm
Print Post Print Post  
The GrandTotal in the footer of the report or the GrandTotal per record?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] My totals are off by a penny
Reply #18 - Oct 2nd, 2007 at 9:40pm
Print Post Print Post  
Per record.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: [Solved] My totals are off by a penny
Reply #19 - Oct 3rd, 2007 at 12:54pm
Print Post Print Post  
Yes you will want to round that per record and store the rounded value.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved] My totals are off by a penny
Reply #20 - Oct 3rd, 2007 at 1:16pm
Print Post Print Post  
Thanks Ray!  And Ben!  And Erika!
  

**
Captain Infinity
Back to top
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print