


I have an actual hours column (Project >> Actual Hours) in a report, and I want to only show actual hours logged for certain roles. Any ideas on how to filter just that column for this?
Additionally, the column's results includes the words "Hour" or "Hours" after the value. Any idea how to only show the number?
Thanks in advance!
Views
Replies
Sign in to like this content
Total Likes
Hi Justin -
You can do this with a valueexpression in the column like this.
displayname=Hours by Job Role
listdelimiter=<br>
listmethod=nested(hours).lists
textmode=true
type=iterate
valueexpression=CONCAT({assignedTo}.{name}," (",{role}.{name},") - ",{workRequired}/60,IF({workRequired}/60>ABS(1)," Hours"," Hour"))
valueformat=HTML
This may not be exactly correct depending on what 'type' of report you're creating.
Hope this helps,
Teale
Views
Replies
Sign in to like this content
Total Likes