Column Total off by 0.01 in summary report

Question

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?

eric_j_hansen · Answer

change your decimal settings to 3 places instead of 2. that might help you find a couple outliers.

quickbasecoachd · Answer

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 · Answer

Ah yes, someone had inputted a third decimal place in an entry and it was rounding up

Forum Discussion

Column Total off by 0.01 in summary report

Related Content

Summary Reports

Default column widths on embedded reports obscuring data

Report Column labels not saving

Rearrange Fields/Columns in table

Hide empty columns in kanban report?