Skip to main content
J
Justin_Charles
Level 3
September 16, 2022
Question

Filtering/customizing 1 column in a report

  • September 16, 2022
  • 1 reply
  • 528 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

T
TealeMcCleaf
Level 6
September 16, 2022

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

Terms & ConditionsAccessibility statement

Loading footer...