2. ASPRunnerPro General questions
  3. Column's Total value on list pages are incorrect
This topic is locked

Column's Total value on list pages are incorrect

 		8/24/2011 10:26:45 PM
ASPRunnerPro General questions
G
 guntherg author

Has anyone encountered a problem where the column total at the bottom of a list page is incorrect?

I am running ASPRunnerPro 5.2 Build 412 and have found that on more than one of my list pages, when the conditions are right, the Total for the Total Amounts column will be off slightly (shown here by .90 cents) and always displays 3 digits past the decimal place. (The correct value should be $217.00)

Example #1
If I adjust the units + or - either way, then the total is correct, as see in example #2

Example #2
That is, until you adjust the units to hit that "magic place" again. In this example, I mixed the numbers up a little but noticed that if 4 of the units values were an odd number, then the Total of the Total Amounts were off again by the same amount. See examples #3 and #5. (The correct value should be $252.00)

Example #3

Example #5
By adjusting the units values so no more than 2 are ending with an odd number, the Total is correct again as shown in example #4

Example #4
Really weird, huh! It doesn't give you much confidence in the totals, either. I have reset/redesigned the list pages and have rebuilt the project from scratch again with the same results. If anyone can give me an insight on what direction to go or what area to look at to solve this issue, it will be greatly appreciated. Thanks. -Gene-
Sergey Kornilov admin 8/25/2011

Hard to tell what exactly might be wrong without seeing the actual data however here are some ideas.
I guess in first example the actual field value is 21.69. Being displayed as Currency it's rounded to 21.70 however totals calculation takes into account the real value (21.69) and rounds the whole sum. I would suggest to set 'View as' type of this field to nothing to see what difference it makes.
If you need more help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
G
 		guntherg author 8/25/2011

The actual values in the Access(2003) db table are 31.00 for units (Number,Single,Fixed Format,2 Decimal Places) and $0.70 for the Unit Price (Currency,2 Decimal Places) I expanded the fields in the database to 8 places past the decimal and the values are still the same (except more zeros on the end). I thought maybe it was a rounding issue but if it were a rounding issue too, but then the total would be incorrect after 2 or 3 record entries. Also, it's never off by pennies but always by .90 cents. The Total becomes incorrect on the entry of the 10th record and any further unit or record entries results in the total becoming correct again. If I change the Unit Price to .80 cents or .60 cents, the total is always correct.
I tried as many things as I could think of today to troubleshoot this issue, but resulted in no change to the outcome at all. Some of the things I tried were:

Changed the 'View as' type on the total field to nothing in ASPRunnerPro

 Changed the 'View as' type on the total field to 'Number' in ASPRunnerPro

Changed the Unit Price field from 'Currency' to 'Number' in ASPRunnerPro and the db

 Changed the Unit Price field from 'Single' to 'Double' in the db

_ Changed the Total Amount(row) field from 'Currency' to 'Number' in ASPRunnerPro
It is weird in that I have had no other instances of this problem with this build during the last 3 years. It's almost as if the processor is not able to carry the one from the tenths to the ones when we have this particular sequence of values. It happens on all the list pages in the build. Even when it is exported to an Excel spreadsheet. Any other thoughts?



Hard to tell what exactly might be wrong without seeing the actual data however here are some ideas.
I guess in first example the actual field value is 21.69. Being displayed as Currency it's rounded to 21.70 however totals calculation takes into account the real value (21.69) and rounds the whole sum. I would suggest to set 'View as' type of this field to nothing to see what difference it makes.
If you need more help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
Sergey Kornilov admin 8/26/2011

If setting 'View as' type of this field didn't help I can suggest to try ASPRunnerPro 6.3. Probably this is v5.2. bug.
If nothing helps post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.