Column Total off by 0.01 in summary report

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
The total I am getting is 0.01 off and I kept seem to figure out what is causing it. I have been through the reports being pulled individually and cannot find this mysterious 0.01, although in a running total is does give 26.05 as it should to total to. What are things I should be looking that cause this?

Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
change your decimal settings to 3 places instead of 2. that might help you find a couple outliers.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
The issue is one of rounding on the display vs what is really in the fields.  The only sure way to prevent is to round the underlaying data to 2 places using the round function.

Round([my numeric calculated field],0.01)
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
Ah yes, someone had inputted a third decimal place in an entry and it was rounding up