Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Filtering/customizing 1 column in a report

Avatar

Level 2

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!

1 Reply

Avatar

Level 7

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