Post

8 followers Follow
8
Avatar

(CR-319858)→Allow customer to remove"h" next to duration in reports

In a report or export allow Duration of "Work" hours to be exported/displayed in hours without the "h". Customers may have another reporting system (i.e. Excel) that they need to pass the exported data though that cannot read the numeric fields when the "h" is there.
Vanessa Michau Not planned

Please sign in to leave a comment.

6 comments

0
Avatar

We needed this too, had to use a custom field just to remove this to allow download to Excel

Phil Smith 0 votes
Comment actions Permalink
0
Avatar

Phil I added you to the list of requesters for this feature request.

Danielle Lasirona 0 votes
Comment actions Permalink
1
Avatar

How this is not implented yet?. we have to do a post procesing script on excel to remove the "h"... the h is not very useful in the excel reports

fernando castro 1 vote
Comment actions Permalink
0
Avatar

Fernando,

We put a custom action action in place that converts the value to a decimal.  We only ever work in hours and never days or weeks etc. so this works well for making all our duration are a number so that we can sum it when exported to excel without need to do post processing.

Our custom field contains the code - $Duration/hours(1) 

Phil Smith 0 votes
Comment actions Permalink
0
Avatar

The Recommended syntax $duration/hours(1) is not allowed when adding a formula column to a report. An error message will appear when checking the syntax and state that the Hours(1) function can only be used on a Calculated field.

 

Coates, Kimberly 0 votes
Comment actions Permalink