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

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
112
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

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

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

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Can you use

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

    Regards,

    Brajesh

  • Jim Mcdonald
    Jim Mcdonald Rank 3 - Community Apprentice

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

  • Ruchika Gujral-90984
    Ruchika Gujral-90984 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

  • Ruchika Gujral-90984
    Ruchika Gujral-90984 Rank 3 - Community Apprentice

    Hi Brajesh,

    We are using

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

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 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

  • Ruchika Gujral-90984
    Ruchika Gujral-90984 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.

  • Ruchika Gujral-90984
    Ruchika Gujral-90984 Rank 3 - Community Apprentice

    image

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Can you see from application correct template is getting picked up