Decimal field using percent format does not render decimal positions in reports

Question

Decimal field using percent format does not render decimal positions in reports

Closed this issue 8 years ago · 1 comments

A decimal field using a percent format like 19.34% works fine in a document, but in the report, it only appears as 19%, even though both the report and the document are using the same decimal format.

Answer 1 · 2016-07-07T22:16:04.000Z

The money/decimal fields for reports are stored in the table esf_tran_report_field_numeric, which was defined as 15 digits and having 2 decimal points. For traditional decimal/money, this was adequate to have 2 decimal points precision, but when the decimal is used for percentages, and we allow up to 2 decimal points in a percentage, we actually need a precision of 4 decimal digits. Altered the table to be NUMERIC(17,4) instead of NUMERIC(15,2).