You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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).
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.
The text was updated successfully, but these errors were encountered: