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.