Handle null with aggregate totals

cjm13905

<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>

kclark

<p>I don't have too much maximo experience but why aren't you using an aggregation item in the footer of the table instead of scripting and using that variable.  Once you use an aggregation item you can call it later in the expression builder to perform more calculations.</p>