Issue with rounding of number values in Metastorm v9

Xavier Garcia

Hello,

 

I would like to report an issue that I have found in Metastorm v9.1.3 in relation to the rounding of number values in grid.

 

Consider the following grid:

 

 

This grid contains the same number in column 1 and column 2. In column 1, we display 6 decimals, while in column 2 we display 2.

 

How come 4.725 gets rounded down to 4.72 while the rest are getting rounded up?

 

Is this a bug in Metastorm?

 

By the way, this grid is displaying Column1 and Column2 in the following query busines object:

select 0.725000 as 'Column1', 0.725000 as 'Column2'
union
select 1.725000 as 'Column1', 1.725000 as 'Column2'
union
select 2.725000 as 'Column1', 2.725000 as 'Column2'
union
select 3.725000 as 'Column1', 3.725000 as 'Column2'
union
select 4.725000 as 'Column1', 4.725000 as 'Column2'
union
select 5.725000 as 'Column1', 5.725000 as 'Column2'
union
select 6.725000 as 'Column1', 6.725000 as 'Column2'
union
select 7.725000 as 'Column1', 7.725000 as 'Column2'
union
select 8.725000 as 'Column1', 8.725000 as 'Column2'
union
select 9.725000 as 'Column1', 9.725000 as 'Column2'

 

Can you please assist?

Thanks in advance.

Jerome_Pearce

It is very odd. I get the same results.

Tony Wheeler

I've also duplicated this in 9.1.0. I thought this might have to do with the default rounding behavior of .net (banker's rounding), but the behavior isn't consistent and the values in the dom reflect the entire queried value un-rounded so it appears to be happening in the browser. Please submit a ticket to bpssupport@opentext.com.

Tony Wheeler

As a workaround in the meantime, you can try ROUND() in the sql query that feeds your bo.

Xavier Garcia

Thanks for your replies.

Just to let you know, I have reported this issue to bpssupport@opentext.com.

Xavier Garcia

The Metastorm support team have contacted me with the following update:

 

---

The development have recognized this issue as a defect (Ref# 17801) and will plan to include the fix in future release version.

---