Forum Discussion
PBI adding fractional decimal numbers
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
Thanks.
Yeah, I get that and understand. I'm a noob at PBI, but an old IT guy. That is a problem that we've been dealing with for a lot of years. However, that is primarily a processor problem, not a software problem.
So, a number like 4395.2300000000000000000000000000000000000 (I didn't count the decimal places) shouldn't be getting rounded up or down or dropping precision. That problem applies to something like 4395.2345876132456698732475632234 (again, arbitrary and didn't count the decimal places), as in an engineering or astronomical calc.
Summing $4395.23, and then splitting it out again should be extremely clean...in our modern software world.