(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Report problem (Read 572 times)
ST
Member
*
Offline



Posts: 9
Joined: Apr 5th, 2011
Report problem
Mar 25th, 2015 at 2:23am
Print Post Print Post  
When printing a report showing total amount, there is a 0.01 difference sometimes. any help to solve this puzzle is appreciated.
I am running a report showing credit and debit amount with running balance and suddenly there is a 0.01 difference when printing the report
Example: the previous balance is 15,539.83 and after adding a credit of 4,851.60, the balance shows 20,391.42

Problem solved, just delete the record of 4,851.60 and add the same record again, and report shows correctly.
« Last Edit: Mar 25th, 2015 at 4:13am by ST »  
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: Report problem
Reply #1 - Mar 25th, 2015 at 5:07pm
Print Post Print Post  
If the value is calculated by programming you can end up with digits in the 3rd, 4th, etc decimal position. For example figuring tax on a purchase

$25 * .0675 = $1.6875 in tax

If you do not use @Round(), @DefinedRound(), @Decimals() or some other rounding routine, your total sale value will be stored as $26.6875 but will most likely show as $26.69 due to your element formatting. In a report that is totaling the calculated fields, the grand total may appear off as it is totaling the raw field values.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge