Forum Discussion

dkat's avatar
dkat
New Member
3 years ago

Rounding problem

Hi all, I'm having a problem with a financial report. For some reason, three months of the year (Oct-Dec) in my report are rounding my currency values, while the rest of the months of the year are n...
Need Help
PabloDeheza's avatar
PabloDeheza
Icon for Solution Sage rankSolution Sage
3 years ago

Hi dkat !
Seems correct to me, since 1.996 is rounding to 2.00 and 2.041 is rounding to 2.04

dkat's avatar
dkat
New Member
3 years ago

It is rounding correctly, but I don't want it to be rounding the values. January-September months are not rounding the data, Oct-Dec months are. Why would 1/3 of the report be showing rounded values?

  • dkat's avatar
    dkat
    New Member
    3 years ago

    Also, I'm referring to the data in the table below the chart, not the values shown above the bar chart. Thanks!

    • PabloDeheza's avatar
      PabloDeheza
      Icon for Solution Sage rankSolution Sage
      3 years ago

      oh got it, have you double check that the data in your model is not rounded for those months as well?

      • dkat's avatar
        dkat
        New Member
        3 years ago

        When I click on the Data tab, it shows that data is rounded there for the months of Oct-Nov, but it's all in the same column so I can't figure out why it would round some months and and not others. When I look in the Excel source document that the numbers are pulling from, the data is not rounded there.