Discussions

Expand all | Collapse all

Column Total off by 0.01 in summary report

  • 1.  Column Total off by 0.01 in summary report

    Bronze
    Contributor
    Posted 05-31-2017 20:20
    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?



  • 2.  RE: Column Total off by 0.01 in summary report

    Bronze
    Contributor
    Posted 05-31-2017 20:46
    change your decimal settings to 3 places instead of 2. that might help you find a couple outliers.


  • 3.  RE: Column Total off by 0.01 in summary report

    Posted 05-31-2017 21:01
    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)


  • 4.  RE: Column Total off by 0.01 in summary report

    Bronze
    Contributor
    Posted 06-01-2017 13:39
    Ah yes, someone had inputted a third decimal place in an entry and it was rounding up