Show Full Numbers Instead of K/M in Project Workspace

[keisuke miya]

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 · Accepted solution]

@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

[Mark Manders]

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. 

[keisuke miya]

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 · Accepted solution]

@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

[keisuke miya]

Hi @Bhuvan  
Thank you for the detailed explanation.
I will also check with the ServiceNow support team when making any script changes.

Hi @Dheeraj Bharsiy 
I appreciate your guidance.