nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

aggregation returning NaN

rafavs86

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: 
 
<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>
 
however If I something like: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>BirtMath.subtract(dataSetRow["diySales::RTL_FW_TY"],dataSetRow["diySales::RTL_FW_LY"])/500</pre>
 
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? 
 
BTW I'm using the SUM function.

Find more posts tagged with

Comments

kclark

Hi rafavs, what error are you getting with the first code example?

rafavs86

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="113071" data-time="1357672130" data-date="08 January 2013 - 12:08 PM">
Hi rafavs, what error are you getting with the first code example? </blockquote>
 
 
Hello kclark, I used safedivision and it solved the issue so I guess somewhere along the agregation there is a 0 value