Forum Discussion
PBI adding fractional decimal numbers
PBI seems to add extended decimal numbers. Sample below. I am pulling in data from SQL Server 2K8. They are Decimal columns. In the query they are cast as Money (a view, actually). I've tr...
Hi WTNetAdmin
As v-sihou-msft mentioned above, these could be solved by added fata format with "Modelling" tab above, where you can set 2 digits after delimeter format. I think that problem itself lies in Double-precision floating-point format
I should have added...if I have to apply formatting, with this situation, I end up with rounding errors of + or - a penny in the individual row items, becuase of the fractional artifacts.