Forum Discussion
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...
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.
If it is rounded in the data tab but not in the excel sheet then the problem must be somewhere in the middle, like power query. Take a look at the steps you have applied in Power Query, maybe one of those steps is rounding those numbers