Default currency values in lists

  • Release version: Zurich
  • Updated July 31, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Default currency values in lists

    In ServiceNow lists, default currency values are displayed in the user’s session currency and formatted according to the user’s locale. This ensures that currency amounts are presented in a familiar and relevant format for each user. Different currency-related field types—such as Currency, Price (Calculated, Fixed, Multiple)—display values based on specific rules tied to the session currency and reference currencies.

    Show full answer Show less

    Currency Display and Interaction

    • Currency field type: Values appear in the user's session currency.
    • Price field type:
      • Calculated: Shows value in session currency.
      • Fixed: Shows the currency value as entered by the user.
      • Multiple: Displays the value associated with the session currency if available; otherwise converts the first entered value.
    • A Globe icon appears next to currency values when the session currency differs from the entered currency. Clicking this icon cycles through views of the value as entered, in session currency, or both with reference currency shown.
    • Preview screens display currency values as entered, formatted for the user’s locale.

    Aggregation of Currency Values

    Currency columns support aggregation functions such as total, average, minimum, maximum, and group by. Aggregation follows a two-step process:

    1. Aggregate the reference currency values from all records.
    2. Convert the aggregate to the user’s session currency for display.

    Important considerations: Aggregated values may differ from expectations due to changes in conversion rates over time and differences in price types. For example, fixed price fields might have outdated reference values, and multiple price fields only use the first entered reference value for aggregation. Currency values and aggregates maintain four decimal places; to preserve this after upgrades, the glide.currencyprice.useallfractiondigits property must be set.

    Filtering Currency Values

    Filters on currency fields require entering a currency code and numeric value. Filtering occurs in two steps:

    1. The filter’s entered currency value is converted to the reference currency.
    2. The filter’s calculated reference value is compared against record reference values to determine matches.

    Note on filtering accuracy: Filter results may sometimes be unexpected because conversion rates used during filtering might differ from those used when the record values were calculated. This limitation also applies to fixed and multiple price types, with fixed prices possibly using outdated reference values and multiple prices only considering the first entered reference value.

    In lists, default currency values appear in the user’s session currency, formatted for display in the user’s locale. Typically, a formatted number follows the currency symbol.

    Different field types appear as follows in lists:
    Field Description
    Currency field type Value expressed in the user’s session currency.
    Price field type
    • Calculated: Value in the user’s session currency.
    • Fixed: Currency value, as entered by the user.
    • Multiple: Value associated with the user’s session currency if this value exists. Otherwise, the first value entered converts to the user’s session currency.
    A Globe icon appears beside the currency value that enables you change to one of the following values:
    • Value as entered by the user.
    • Value in session currency.
    • Value as entered and, in brackets, the value in reference currency.

    The icon appears when the user’s session currency is different from the currency entered. Clicking the icon cycles through the listed displays. In the preview for the record, currency values appear as entered, formatted in the user’s locale.

    Aggregation

    Aggregation operations can be used on currency columns. Aggregation operations include total, group by, average, minimum, and maximum. Aggregation is done in two steps:
    • Aggregate the reference currency values for all records.
    • Convert this aggregate to the user’s session currency for display.
    Note:
    The resulting value may not be what you expect. The conversion rate used for the value that appears for the currency field, and for its reference currency, that is used for the aggregation, may have changed.
    This limitation extends to different price types.
    • For price type fixed, the calculated reference value can be old.
    • For price type multiple, the reference value of the first price entered is used. The other values are not used.

    The aggregate value is shown formatted in user’s locale with a currency symbol. Currency fields are stored with four decimal places, and aggregates have four decimal places. For upgrades, you must set the glide.currency_price.use_all_fraction_digits property. See Change default currency decimal places for more information.

    Filtering

    You can set up filters on currency fields. The currency value is entered as a currency code and numeric value. Filtering is done in two steps:
    • The filter currency value is converted to the reference currency.
    • The filter’s calculated reference value is compared with the reference value in the records.

    Matching records are shown in the list view.

    Note:
    At times, the filtering results might not provide the expected result. The conversion rate used when you run the filter might be different than the conversion rate used when calculating the reference values in the individual records. This limitation extends to the following price types:
    • For a Fixed price field type, the calculated reference value can be old.
    • For a Multiple price field type, it uses the reference value of the first price, and does not use the other values.