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
aggregation returning NaN
Migrateduser
I'm fairly new to BIRT and I need some guidance on how to work with aggregations, for some reason I get an error when I aggregate using the following expression:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>BirtMath.subtract(dataSetRow["diySales::RTL_FW_TY"],dataSetRow["diySales::RTL_FW_LY"])/dataSetRow["diySales::RTL_FW_TY"]</pre>
<br />
however If I something like:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>BirtMath.subtract(dataSetRow["diySales::RTL_FW_TY"],dataSetRow["diySales::RTL_FW_LY"])/500</pre>
<br />
It goes thru, even If use the hardcoded value of dataSetRow["diySales::RTL_FW_TY"] it works!, I dont really know what could it be wrong, do I have to split the aggregation steps?<br />
<br />
BTW I'm using the SUM function.
Find more posts tagged with
Comments
There are no comments yet