Skip to main content
Question

Column Total off by 0.01 in summary report

  • June 1, 2017
  • 0 replies
  • 81 views
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?

      • EricJHansen
      • Registered
      • June 1, 2017
      change your decimal settings to 3 places instead of 2. that might help you find a couple outliers.
      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)
      • JordanBeatty1
      • Author
      • Registered
      • June 1, 2017
      Ah yes, someone had inputted a third decimal place in an entry and it was rounding up
      Terms & ConditionsAccessibility statement