Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Float and Decimal point
Migrateduser
<p>Newbie to BIRT, and we have version 3.7.1</p><p> </p><p>I have an existing report that has a dataset with a field called laborhrs which is a string in the birt dataset and a FLOAT on the Oracle Table. I then have an aggregate field called table_laborhrs which is FLOAT and uses the function SUM. This is working and displays the hours with a decimal.</p><p> </p><p>I tried to duplicate this in another report, but the totals field is not displaying decimals and is rounding.</p><p>Where it is not working I also used a aggregate field, which is FLOAT and uses the SUM function.</p><p> </p><p>I threw in a aggregate runningsum, that was float, and on the first records which in the Database is 7.5 </p><p>on the BIRT report it shows 7</p><p> </p><p>In the properties for the aggregate field in both reports the Format Number is :</p><p>Format as: Unformatted</p><p>Local : Auto</p><p>Preview with format 1234.56</p><p> </p><p>I've tried changing the total field Format Number to various formats (General Number, Currency) which</p><p>gets me the decimal positions, but still rounds.</p><p> </p><p>Any help is appreciated.</p><p> </p><p> </p><p> </p>
Find more posts tagged with
Comments
There are no comments yet