Show Full Numbers Instead of K/M in Project Workspace

keisuke miya · 4 weeks ago

Hello everyone,

I have a question about the Financials section in Project Workspace.

At the top, amounts are displayed using abbreviations like "K" and "M."
Is there a way to show the full numeric values instead?

In Japan, it's standard to display full amounts without abbreviations—for example, showing 100,000 instead of 100K, or 1,000,000 instead of 1M.

I would like to display the amounts without using "K" or "M."

Thank you,

Bhuvan · 3 weeks ago

@keisuke miya

Check with ServiceNow if this can be managed via System Properties. Here is the alternative option,

All the information you are seeing in Workspace comes from Widgets. For example, let us take 'Planned Cost' widget that contains 'Capex' and 'Opex'. Workspace Widgets can be accessed from table 'sn_app_widget'.

Below is a sample Financials displaying Planned Cost, Capex and Opex with abbreviation [default]

Go to 'sn_app_widget', search for 'Planned Cost' and open the record. Comment the displayValue that formats the currency and use the actual value to display the financials without abbreviation. Repeat same steps for Capex and Opex Child Widgets

var context = JSON.parse(context);
var investment = context.investment;

(function getCost() {
	//Note: return the value in below format in order to achieve color formatting of negative values
    return {
        value: investment.cost.value,
        //displayValue : PPMCurrencyHelper.getFormattedAmountWithCurrency(investment.cost.value)
		displayValue: investment.cost.value
    };
})();

Below is the Widget after the changes,

You can revert back the change to use system default. Please note, this is for testing purposes only and do not recommend you to change the settings without confirmation from ServiceNow support team as it might not be officially supported and could lead to technical debt.

If this helped to answer your query, please accept the solution and close the thread.

Thanks,

Bhuvan

View solution in original post

Dheeraj Bharsiy · 3 weeks ago

Hi @keisuke miya

In order to show the currency display value instead of showing the short format values, we can update the widgets to use displayValue property which is already being returned from the widget api.

As @Bhuvan mentioned, we need to update the script of the individual widget but the only difference is we need to use displayValue property which honour the locale of the instance.

Example of updated script from one of the widget:

value: investment.work_cost.value,
displayValue: new global.UserLocaleUtil.getGlobalLocale().currency_symbol+""+investment.work_cost.displayValue,

If you also need to have currency symbol before the currency value, you can use the global UserLocaleUtil api as above.

View solution in original post

Mark Manders · 3 weeks ago

I don't have Project Workspace on my instance, so I don't know if it's a report created in UI builder, or an inline dashboard that is showing, so you need to check where the report is created yourself.

Once you have, open it and check on the metric. It has a 'format values' link, where 'enable abbreviation' is set to true. If you move this to false, you will see the entire number. It could mean that you also need to check on the display settings, so it auto adjusts to the size of the number.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

keisuke miya · 3 weeks ago

Hello Mark,
Thank you for the information.
I understand that the Project Workspace is created using the UI Builder, but I wasn’t able to locate the 'format values' link.
I’ll continue looking into it.

Thank you,
Keisuke

Bhuvan · 3 weeks ago