Display a value as percentage?

[mikeellis]

After scanning through the documentation, the developer community here and good-old-google, I cannot seem to find an answer to an incredibly simple problem...

Can I specify a display format for a field in ServiceNow that will store a floating point value and display/capture it as a percentage?

Desired Outcome:

Identifier (string)	Threshold (float)
abc	75%
def	65%

Usage: User types "7 5 <enter>" into a field and system translates this as "75%" and stores the percentage in decimal format (0.75)

Actual Table:

Identifier (string)	Threshold (float)
abc	0.75
def	0.65

Thanks in advance!

Regards,

Mike

[Chuck Tomasi]

Hi Michael,

There is a special field type used in ServiceNow for Percent Complete. It also gives you the ability to represent the percentage as a bar chart in lists.

Creating a Percent Complete Field - ServiceNow Wiki

[mikeellis]

Hi Chuck,

Appreciate the quick response, however perhaps I should clarify - I've looked at the Percent Complete field already, however this does not fit my need very well... I'm looking to capture a percentage-based target / threshold from the user, and displaying this value as a Progress Bar very much confuses the meaning...

Is there no way to define a display format for an underlying field?   With all of the power of ServiceNow, I imagined this would be trivial and that I was simply missing where to define it...

[Chuck Tomasi]

Thank you for the explanation Michael,

As simple as it seems, the only way I know is a simple integer or decimal field to hold a raw number.