nvision amounts not rounding correctly

Hi All,

I am facing a different issue when working on an nvision.

The underlying query gives the correct amount when ran separately in PSQuery or SQL developer, but the rounding is different when the nvision is ran.

The query is similar like below

-- select round(sum(posted_total_amt)/1000,0) from .....

and if the result is suppose 332769952.57 then psquery and sql developer give 3327700 but nvision gives 3327699.

i used Accounting format in the nvision.

Dis anyone face similar issues or any suggestions?

Thanks'

Rajani