Removing the 'Hours' Text From Results

[khryc]

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

[Sheri_Whitten]

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

[khryc]

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?

[Sheri_Whitten]

What kind of report are you using? I tried this on a task report and it worked to return only the numerical values 

[khryc]

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

Thanks

[Sheri_Whitten · Accepted solution]

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

[khryc]

this worked!! thanks so much, I appreciate your time.

[J_Mas]

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

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

[khryc]

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