You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Publisher eText (Fixed Position) Number formatting issue.

Summary:

Hi everyone,
I’m working on a BI Publisher eText template (fixed-position layout). I have a column that must display an amount as a 13‑character, left‑padded numeric string with no decimal point (e.g., 0000000044971). The value is also wrapped in an IF condition before rendering.

Issue:
For a few records (not all), the output shows a decimal point (e.g., 449.710000000) instead of a 13‑digit integer. The zero‑padding/formatting is inconsistent. I’ve attached a screenshot of the eText field expression and the output (yellow highlights where it’s wrong).

The formatting works for most records but fails for a few, which is strange. If anyone has faced this inconsistency in eText formatting and knows how to reliably force the value into a 13‑digit, zero‑padded, no‑decimal output—especially within an IF condition—please suggest what might be going wrong or the best way to fix it.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!