Incorrect number in BI Publisher text field (rtf template)
Hi there,
BI Publisher data model returns 2 numbers as chars:
select
fiscalyear,
Fromdate,
Todate,
aww AWWtest,
sww SWWtest,
to_char(aww,99.99) AWW,
to_char(sww,99.99) SWW,
When I run the query in PL/SQL Developer I get expected values for AWW, SWW:
But rtf template field below converts it to 38 in one BI Publisher Test environment, but works fine in another.
What is the issue with BI Pub configuration when it shows 38 instead of 37.5 in pdf output file?
Here is how those fields are defined in rtf template.
Thanks,
Edward.