Filtering/customizing 1 column in a report

[Justin_Charles]

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!

[TealeMcCleaf]

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