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
Sum labour hours on report
Migrateduser
I am trying to write a simple report which groups labour transactions by date, then laborid, then labortype. I have got the format set up fine, but having issues with the aggregation.
I have summed the the 'regularhrs' field, and this displays, but as a decimal. The 'regularhrs' is in an hh:mm format though, so for example the entries 03:00 and 00:15, the sum is shown as 3.0, rather than 03:15 (or even 3.25). Does anyone know how I can get the total to display as a hh:mm format?
Find more posts tagged with
Comments
There are no comments yet