That would indeed be useful.
Comment actions
Post
Follow
(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.
|
Please sign in to leave a comment.
7 comments
Date
Votes
We needed this too, had to use a custom field just to remove this to allow download to Excel
Comment actions
Phil I added you to the list of requesters for this feature request.
Comment actions
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
Comment actions
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)
Comment actions
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.
Comment actions
Adding my vote; because we cannot access any of those Hours, Days, etc functions in the report editor. Creating a Custom Field just to do a conversion for Duration into a Numeric is really "overkill" and instead the Report Module needs to be enhanced to let us create Custom Formula fields "on the fly".
But I guess I will also join the "custom field" crowd now that I see that others are doing this and they actually do give you a ridiculous amount of Custom Fields.
Comment actions