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 on footer
Migrateduser
I'm trying to calculate a percentage of the total of a table, I use the following:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>var TY=BirtMath.safeDivide(dataSetRow["dyiSales::RTL_FW_TY"],row["DEPT_QTY_TY"],0);
var LY=BirtMath.safeDivide(dataSetRow["dyiSales::RTL_FW_LY"],row["DEPT_QTY_LY"],0);
(TY-LY/LY)</pre>
<br />
but is not giving the expected result, for some reason these variables are gettign a different value along the calculation, im placing an aggregation field at the footer and I'm using aggregate on Table.<br />
<br />
When I print either TY or LY alone the values make sense, but what confuses me a lot is that if I print:<br />
<br />
(LY/LY)<br />
<br />
It wont't give 1 ! how can this be possible? Again I'm doing this on a footer aggregation.<br />
Is there a work around ?
Find more posts tagged with
Comments
There are no comments yet