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
Aggregating getDuration as a Sum - ignores minutes/fractions
Migrateduser
<p>I have a report that is displaying regular hours and overtime hours in columnar format. These fields are fetched as getDuration data. The Data set identifies these fields as "string." I have a group SUM for these fields. The problem is that it only sums the integer and ignored fractions of the hour.</p>
<p> </p>
<p>For instance:</p>
<p>2:00</p>
<p>4:30</p>
<p>1:00</p>
<p>
</p>
<p>7</p>
<p> </p>
<p>How can I get the sum to work correctly?</p>
<p> </p>
<p>Thanks in advance.</p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet