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
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
What kind of report are you using? I tried this on a task report and it worked to return only the numerical values
Views
Replies
Total Likes
Hi Sheri,
Thanks for looking at this, it is a project report. Here is what I get when I try:
Thanks
Views
Replies
Total Likes
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
Views
Replies
Total Likes
this worked!! thanks so much, I appreciate your time.
Try this in Text Mode (it's worked for me):
displayname=Task Actual Hours
textmode=true
valueexpression=CONCAT({task}.{actualworkRequired}/60)
valueformat=compound
Views
Replies
Total Likes
thanks James...this didn't work either...it just returned zero on every line.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies