Removing the 'Hours' Text From Results | Community
Skip to main content
K
khryc
Level 2
February 2, 2023
Solved

Removing the 'Hours' Text From Results

  • February 2, 2023
  • 2 replies
  • 1399 views

Hi everyone,

Could someone help me with the following simple text?

How do I remove the Hours text from the results column, so that it only returns the numeric value without the text?

 

displayname=
linkedname=direct
namekey=actualworkrequired
querysort=actualWork
textmode=true
valuefield=actualWorkRequired
valueformat=compound
viewalias=actualworkrequired

 

Thanks

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 Sheri_Whitten

Hi Sheri,
Thanks for looking at this, it is a project report. Here is what I get when I try:

Thanks


Got it. This was tricky and the credit goes to @kynabaker16, who solved it in this post Remove the string "Hours" when creating a report.. 

 

Here's what worked in my project report:

 

displayname=Actual
linkedname=direct
namekey=actualworkrequired
querysort=actualWork
textmode=true
valueexpression=DIV({actualWorkRequired},60)
valuefield=actualWorkRequired
valueformat=compound
viewalias=actualworkrequired

2 replies

S
Community Advisor
Sheri_WhittenCommunity Advisor
Community Advisor
February 2, 2023

Try actualWork instead, that should give you what you're looking for.

 

displayname=
linkedname=direct
namekey=actualWork
querysort=actualWork
textmode=true
valuefield=actualWork
valueformat=integer

K
khrycAuthor
Level 2
February 3, 2023

thanks Sheri, but that unfortunately didn't work, and it removed all values, so the column is now blank.

I'm looking for it to appear as 00.0 instead of 00.0 Hours

Any ideas?

S
Community Advisor
Sheri_WhittenCommunity AdvisorAccepted solution
Community Advisor
February 3, 2023

Hi Sheri,
Thanks for looking at this, it is a project report. Here is what I get when I try:

Thanks


Got it. This was tricky and the credit goes to @kynabaker16, who solved it in this post Remove the string "Hours" when creating a report.. 

 

Here's what worked in my project report:

 

displayname=Actual
linkedname=direct
namekey=actualworkrequired
querysort=actualWork
textmode=true
valueexpression=DIV({actualWorkRequired},60)
valuefield=actualWorkRequired
valueformat=compound
viewalias=actualworkrequired

J_Mas
J_Mas
Level 5
February 3, 2023

Try this in Text Mode (it's worked for me):

 

displayname=Task Actual Hours
textmode=true
valueexpression=CONCAT({task}.{actualworkRequired}/60)
valueformat=compound

K
khrycAuthor
Level 2
February 3, 2023

thanks James...this didn't work either...it just returned zero on every line.

Terms & ConditionsAccessibility statement

Loading footer...