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

Text mode grouping for hours

  • November 6, 2024
  • 1 reply
  • 443 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_Accepted solution
New Participant
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.