Text mode grouping for hours | Community
Skip to main content
Level 2
November 6, 2024
Solved

Text mode grouping for hours

  • November 6, 2024
  • 1 reply
  • 445 views

Hello,

 

I want to group the hour type report in text mode and show grouping as "Billable" if hour type id is task time or issue time and as "Non Billable" for rest of hour types. Please help me here to achieve this grouping.

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

Hi,

 

The following text mode should do it:

 

textmode=true group.0.displayname=Hour Type group.0.valueexpression=IF({hourType}="Task Time"||{hourType}="Issue Time","Billable","Non Billable") group.0.valueformat=string

 

Best Regards,

Rich.

1 reply

Richard_Le_Community AdvisorAccepted solution
Community Advisor
November 7, 2024

Hi,

 

The following text mode should do it:

 

textmode=true group.0.displayname=Hour Type group.0.valueexpression=IF({hourType}="Task Time"||{hourType}="Issue Time","Billable","Non Billable") group.0.valueformat=string

 

Best Regards,

Rich.