Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

xml file is showing 2 decimal places however pdf output of report shows rounded value

Received Response
116
Views
9
Comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 7 - Analytics Coach

    This should also work....is this not working?

  • Rank 7 - Analytics Coach

    Can you use

    <?format-number:PMFBY11207;'999G999G990D00'?>

    Regards,

    Brajesh

  • Rank 3 - Community Apprentice

    Have you tried applying the format on the Word template field properties? This definitely works.

  • Rank 3 - Community Apprentice

    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.00

  • Rank 3 - Community Apprentice

    Hi Brajesh,

    We are using

    <?format-number(PMFBY11207, '###0.00;(###0.00)')?>

  • Rank 7 - Analytics Coach

    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

  • Rank 3 - Community Apprentice

    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.

  • Rank 3 - Community Apprentice

    image

  • Rank 7 - Analytics Coach

    Can you see from application correct template is getting picked up

Welcome!

It looks like you're new here. Sign in or register to get started.