Rounding errors in reports

Kinetic ERP
,
1

I have a custom BAQ that will show value of parts as a rounded number. It works like this both in the BAQ Test and as the actual report itself.

I copied the BAQ in question and added a few fields, everything is fine, it tests perfectly. It even has the rounded value numbers during Test.

Except when I go to copy/paste into Excel, the number loses its rounding. When I test it as a SSRS report it also shows the rounding loss.

I submitted this to EpicCare and they said they will post it as a bug, but that doesn’t explain to me how it works in one instance and not the other.

Any ideas?

2

Can you try converting your baq field to a string value in a calculated field and see if that helps the situation? I know excel can get stupid when copying dates, numbers, basically anything that can be formatted as something else.

SSRS could be another beast, it might not at all be related to your BAQ. Within SSRS there is way to bake code that runs at run time, add expression to fields, etc.

3

Can you post the expression for one of the fields that you are having issues with? Can you also explain what the rounding error is with an example? Are you expecting 9.99999999999999999 but getting 9.99 instead as an example.

1 Like