Reformat how a field displays - valueformat | Community
Skip to main content
L
LaraMc
Level 2
March 27, 2018
Question

Reformat how a field displays - valueformat

  • March 27, 2018
  • 1 reply
  • 767 views
I need to reformat a field in one of my reports % of hours spent from .13% or .9% to 13% or 90%. Here is the text criteria that it currently is coded as, I am sure that the valueformat needs to change but I can't find what it needs to be changed to: displayname=% of Hours Spent textmode=true valueexpression=DIV({actualWorkRequired},{workRequired}) valueformat=doubleAsPercent Lara McCleary SR Project Manager/WF Adminstrator Aetna Tampa, FL 203-988-5089
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

M
melindal3825541
Level 5
March 28, 2018
ROUND(DIV({actualWorkRequired},{workRequired})*100,1) Would give you 90.1% for example. Round is the number of decimal places to include and actually can be negative to round to the tens place for example. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: www.capabilitysource.com email: melinda.layten@capabilitysource.com Helpful? Buy me a coffee: https://www.patreon.com/mlayten - we simplify your work so you can run your business -
Terms & ConditionsAccessibility statement

Loading footer...