Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Property with value 0 from DB saved as 0E-9 on Clipboard



A property has a value that is equal to zero in the database table. After executing the report definition, the corresponding property displays ‘0E-9’ in the pyReportContentPage on exporting a file to Excel using MSOGenerateExcelFile.
On the UI of the same report definition, the same property displays the value correctly (as zero).

Error Messages

Not Applicable

Steps to Reproduce

Run a report definition containing a column with zero as the value.

Root Cause

A defect in Pegasystems’ code or  rules. Postgres added trailing zeroes when a property of type decimal is created. It created a column with numeric (18,9) data type. To match the scale set on numeric (18,9), the value changes to 13.950000000 (for 13.95). Similarly the value 0 is stored as 0.000000000.


An enhancement request, FDBK-29106, is created for consideration by Pega Product Management.

As a local-change, invoke a function to convert the value from 0E-9 to 0.000000000.


Published December 2, 2021

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us