topic Re: Rounding Error on Total Calculation in Opportunity in Act!
https://community.act.com/t5/Act/Rounding-Error-on-Total-Calculation-in-Opportunity/m-p/306073#M74977
<P>I've seen this before. It's not really a bug because it is working as designed. From working with the reports where I can do calculations based on the actual values I was able to determine that what was happening was that the program calculation was rounding to two desimal places at intermediate steps in the calculation causing the the final amount to be rounded to two decimal places even when more were showing more decimal places.</P><P> </P><P>In a report the correct values could be developed. I can think of a way to use custom fieds and a math addon to display the unrounded values but that would be in addition to the rounded values.</P><P> </P><P>Sorry, I know this wasn't the answer you wanted.</P>Wed, 13 May 2015 17:01:10 GMTRoy_Laudenslager2015-05-13T17:01:10ZRounding Error on Total Calculation in Opportunity
https://community.act.com/t5/Act/Rounding-Error-on-Total-Calculation-in-Opportunity/m-p/305943#M74939
<P>Hi all,</P><P> </P><P>I'm using Act! Pro Version 17.1.169.0, Hot Fix 2 on a Windows 7 Pro machine. We're considering ACT for our company and are using the Trial Version right now.</P><P> </P><P>I'm testing creating an opportunity for a product. The quantity is 800,000 units x $.0298 per unit. I modified the price field to show the extended decimal points beyond 2, however the TOTAL is still incorrectly using the rounded price of $.03. The total should be $23,840 but ACT shows $24,000.</P><P> </P><P>Is it possible to modify the Total and the Weighted Total to use the cost with the extended decimal point rather than the rounded price?</P><P> </P><P>Thanks!</P><P> </P>Mon, 11 May 2015 18:53:04 GMThttps://community.act.com/t5/Act/Rounding-Error-on-Total-Calculation-in-Opportunity/m-p/305943#M74939Eclipse1232015-05-11T18:53:04ZRe: Rounding Error on Total Calculation in Opportunity
https://community.act.com/t5/Act/Rounding-Error-on-Total-Calculation-in-Opportunity/m-p/306073#M74977
<P>I've seen this before. It's not really a bug because it is working as designed. From working with the reports where I can do calculations based on the actual values I was able to determine that what was happening was that the program calculation was rounding to two desimal places at intermediate steps in the calculation causing the the final amount to be rounded to two decimal places even when more were showing more decimal places.</P><P> </P><P>In a report the correct values could be developed. I can think of a way to use custom fieds and a math addon to display the unrounded values but that would be in addition to the rounded values.</P><P> </P><P>Sorry, I know this wasn't the answer you wanted.</P>Wed, 13 May 2015 17:01:10 GMThttps://community.act.com/t5/Act/Rounding-Error-on-Total-Calculation-in-Opportunity/m-p/306073#M74977Roy_Laudenslager2015-05-13T17:01:10Z