@JAM3guitar. I think I have the answer for you on this gnarly decimal place problem. If your report's dollars values are formatted to include the cents decimal places (e.g. $125.48), then the two decimal places of the percentage point will calculate correctly (e.g. 5.91%). If your dollar formatting does not include the cents places ($125). than the percentage will round to the nearest whole number with two decimal places (6.00%).
Is this an insult to mathematics and significant digits? Yes.
Is this a embarrassing math error in a leading software for accurate reporting on accounting numbers? Yes.
Are the responses from the support staff here misunderstanding what your concern and goal is? Yes.
And yet, here we are.
I would love to format the percentage to simply be a whole number percentage (6%), as my report's recipients don't need a percentage to 100th of a percent. It just clutters the report.
I also don't need to report cents on the dollar amounts, as it clutters the report.
but, I absolutely do not want to have incorrect numbers on my report and the .00 percentage is laughably incorrect. Oy.
