Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Why is the amount of Report Builder rounding off on the exported Excel?
Hi again, Back with another issue i can't seem to wrap my head around it.
We have a Report created with the Report Builder. In the screenshot below you can see the settings of the different columns.
The last column uses a formula which multiplies the Partner Percentage with the Gross amount.
The result page is as expected.
6.80% * 4.487,52 = €305,15
When exporting this to Excel (by using the Excel button at the bottom of the result page) i suddenly get a different endresult. This now is €314,13
I found out that the problem occurs because of the ROUNDING of the Gross Amount. If I delete the ROUND (AFRONDEN) or change it to 3 decimals, then the correct result is displayed again.