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
Handle null with aggregate totals
Migrateduser
<p>We use BIRT 3.7.1 with maximo.</p><p> </p><p>We have had limited training and do simple reports.</p><p>We have a report where we list all material costs in a table, all labor costs in a table and all service costs in a table.</p><p> </p><p>At the bottom of the report we want to get the budget amount and subtract these 3 costs.</p><p>We added variables to capture the totals of material, labor and service.</p><p>When we run in BIRT it works okay. When we import it into Maximo it fails and errors.</p><p> </p><p>We did some investigation, and we think the problem is when one of the tables (i.e service costs) returns zero records.</p><p> </p><p>We tried to initialize all the variable total fields to 0.</p><p>In the final calculation we tried to check if the field is null .</p><p> </p><p>We are new to any type of scripting, so if anyone can provide examples it is much appreciated.</p><p> </p><p>Thanks</p>
Find more posts tagged with
Comments
There are no comments yet