Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
How to compute exponential value ?
lixian123
<ol><li>I need to compute row column value in BIRT cross-tab .</li>
</ol><p> </p>
<ol><li>example : 5.240124211265131e power sub 4 ? how to compute it below expression showing zero ('0') instead of exponential value .</li>
</ol><pre class="_prettyXprint">
BirtMath.roundDown(data["JOB_COST_MINUTES_DATE/STAT_TIME_2"]/3600, 2)</pre>
Find more posts tagged with
Comments
Clement Wong
<p>Can you please clarify your question?</p>
<p> </p>
<p>So you have a value such as "0.000524012421126513", and you want it to show just "0"?</p>
<p> </p>
<p>Have you tried using the expression <span>data</span><span>[</span><span>"JOB_COST_MINUTES_DATE/STAT_TIME_2"</span><span>]/</span><span>3600, and then changing the report item's <em>Properties > Format Number</em>.</span></p>
<p> </p>
<p><span>You can select Format as: Fixed with Decimal places: 0. And then select the appropriate Rounding Mode:</span></p>
<p> </p>
<p><span>If this does not work for, please include an example report using the Classic Models that demonstrates your issue so that we can help you further.</span></p>