Hi,
I'm working on a report on Oracle BIEE 11g (11.1.1.6.12) where I have some scientific numbers that should not be rounded. For example, I have a number 0.999999999012345678901 in the database. Its being displayed as 1.0 in the results on the webpage. The issue is that I would like it to display 0.999999 In other words, I want to truncate to after 6 decimal places, and ignore the rest of the value. I do not want it to round up. As another example, there's a value 123.99999999999999912345789 in the database, but its showing up as 124.0 on report. Again, I only want to see 123.999999 on the report.
Right now I'm looking at Column Properties -> Data Format. There's a checkbox for "Override default data format" and one of the pull down options is Custom. Is there any Custom Numeric Format that I can use?
Much thanks,