Rounding and different values in BIRT than in Maximo (BIRT is correct)

Options
wwilliams
edited February 11, 2022 in Analytics #1
<p>In the report designer the values are rounding correctly in Maximo they aren't the same.</p>
<p>For example I have a value of 11.35 which I am formatting to have one decimal place. In Maximo this becomes 11.5 where as in birt and running the sql direct is 11.4.</p>
<p>I have tried just about every combination e.g. number formatting, Birt math functions and performing the rounding in the sql.</p>
<p>I just get different results when the report in run in Maximo.</p>
<p>Anyone else run across this? Is the solution something a simple and I am making this difficult?</p>
<p>3.7.1 and Maximo 7.5.0.3</p>

Comments

  • <p>When you say in Maximo, you mean when you run the BIRT report in Maximo? In other words the same BIRT report runs correctly in BIRT Designer but runs, incorrectly in Maximo? What happens if you give it to decimal places?</p>
  • <p>If I use two decimal places in BIRT it shows .35, in Maximo it shows .60, I put it back to 1 decimal place and now for whatever reason it shows .6 not .5 as before.</p>
    <p>I am not going to worry about it at this point.</p>
    <p> </p>
    <p>Thx</p>