Expand my Community achievements bar.

Come join us for our Coffee Break next week on top takeaways from Adobe Summit!

Filtering/customizing 1 column in a report

Avatar

Level 4

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