Column Total off by 0.01 in summary report
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 runni...
Forum Discussion
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)
Round([my numeric calculated field],0.01)