Removing the 'Hours' Text From Results

Question

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=directnamekey=actualworkrequiredquerysort=actualWorktextmode=truevaluefield=actualWorkRequiredvalueformat=compoundviewalias=actualworkrequired
 
Thanks

Sheri_Whitten · Accepted Answer

Hi Sheri,Thanks for looking at this, it is a project report. Here is what I get when I try:ThanksGot 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=Actuallinkedname=directnamekey=actualworkrequiredquerysort=actualWorktextmode=truevalueexpression=DIV({actualWorkRequired},60)valuefield=actualWorkRequiredvalueformat=compoundviewalias=actualworkrequired

Sheri_Whitten · Answer

Try actualWork instead, that should give you what you're looking for. displayname=linkedname=directnamekey=actualWorkquerysort=actualWorktextmode=truevaluefield=actualWorkvalueformat=integer

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded