Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
xml file is showing 2 decimal places however pdf output of report shows rounded value

Summary
xml file is showing 2 decimal places however pdf output of report shows rounded value
Content
xml file shows:
<PMFBY11207>162101937.68</PMFBY11207>
in pdf output:
162101938.00
Answers
-
This should also work....is this not working?
0 -
Can you use
<?format-number:PMFBY11207;'999G999G990D00'?>
Regards,
Brajesh
0 -
Have you tried applying the format on the Word template field properties? This definitely works.
0 -
No,am using this formatting on all fields of the rtf.
As per my analysis , when decimal places are more than .50 its rounding to nearest integer.
For <MNAIS11207>1285646.21</MNAIS11207> value is fine in pdf.
Issue is with below two,both with decimal point greater than .5:
<TNAIS11207>163387583.89</TNAIS11207> rounded to 163387584.00<PMFBY11207>162101937.68</PMFBY11207> rounded to 162101938.000 -
Hi Brajesh,
We are using
<?format-number(PMFBY11207, '###0.00;(###0.00)')?>
0 -
This format will absolutely work. Looks like some other type issue, could you check PMFBY11207 field in rtf contains <?format-number(PMFBY11207,'###0.00;(###0.00)')?> only?
Please check the HELP KEY(F1) tab if anything is there? Also declare that field as Number, currently its Regular Text.
Please upload the sample RTF and XML if issue still exists
0 -
Help key is blank.
Another observation is excel and pdf preview on my system works fine, only output after running custom report on instance gives the issue.
0 -
0
-
Can you see from application correct template is getting picked up
0