Data formats model settings

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Data formats model settings

Use the settings in Data Formats to determine the default format for date, number and currency fields in Supply Chain Guru X tables in the current model. You can override these settings for individual fields using the Column Formatting option in the data table.

Changing the data formatting does not affect the underlying data values.

Set the default data formats

Select Model > Model Settings > Data Formats. You see options for Date, Number and Currency field formatting. Each category provides a preview of how the data will be displayed.

Type	Setting	Description
Date	Date Format	Select the format you want to use for dates when displaying Date/Time fields. Options include: Short Date - Displays numeric day month and year, such as 04/12/2018 Long Date - Displays text day and month, such as Thursday, April 12, 2018 Values are displayed based on the current Model Culture.
Date	Time Format	Select the format you want to use for dates when displaying Date/Time fields. Options include: Do not display - No time component is displayed. Short Time - Displays hours and minutes, such as 5:10 PM Long Time - Displays hours, minutes and seconds, such as 5:10:18 PM
Number	Decimal Places	Use this setting to determine the number of decimal places to display for number fields.
	Negative Values	Use this setting to control how negative number values are displayed. For example, prepend the value with a minus sign (-), or enclose the value in parentheses.
	Use Thousands Separator	Use this setting to determine whether or not to display the thousands separator for number columns. For example, when the switch is off, values are displayed as 1234.56. When on, they are displayed as 1,234.56. The character used for the thousands separator is based on your computer regional setting.
Currency	Decimal Places	Use this setting to determine the number of decimal places to display for currency fields.
	Currency Symbol	Use this setting to determine the position for the currency symbol in output table columns: Display to the right of the value Display to the left of the value Hide The currency symbol used is the one associated with the Currency on the Units and Currency tab.
	Negative Values	Use this setting to control how negative currency values are displayed. For example, prepend the value with a minus sign (-), or enclose the value in parentheses.
	Use Thousands Separator	Use this setting to determine whether or not to display the thousands separator for currency columns. For example, when the switch is off, values are displayed as 1234.56. When on, they are displayed as 1,234.56. The character used for the thousands separator is based on your computer regional setting.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No