Expand my Community achievements bar.

Remove Hours

Avatar

Level 2
Is there a way to remove the word 'Hours' from a report? For example when the report runs that shows planned planned hours we would like just the number....40 instead of 40 Hours.
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10
Try this - replace workRequired with whatever the field name is you are doing. displayname=Planned Hours listsort=int querysort=workRequired textmode=true valueexpression={workRequired}/60 valuefield=workRequired valueformat=compound viewalias=workrequired Michael Lebowitz Marketing Analyst Michael.Lebowitz@guidewellconnect.com< T 904-436-4240 | M 904-200-1364 Fax 904-565-6156 4800 Deerwood Campus Pkwy DCC 800-4-272 Jacksonville, FL 32246

Avatar

Level 10
This might show up twice in the forum as it got flagged originally as a support email. I used the following text mode to remove the hours from the column. displayname=Planned Hours listsort=int querysort=workRequired textmode=true valueexpression={workRequired}/60 valuefield=workRequired valueformat=compound viewalias=workrequired Michael Lebowitz Marketing Analyst Michael.Lebowitz@guidewellconnect.com< T 904-436-4240 | M 904-200-1364 Fax 904-565-6156 4800 Deerwood Campus Pkwy DCC 800-4-272 Jacksonville, FL 32246 ________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the author’s employer and it is not responsible for errors, omissions or any comments reflecting personal views in this email. The information is intended solely for the individual(s) or entity addressed. It may be confidential or contain material that is privileged or protected from disclosure under applicable law. If you are not the intended recipient, please be advised that any use, dissemination, forwarding, or copying of this email and its contents IS STRICTLY PROHIBITED. Please notify sender immediately and delete this email and its contents.