Default currency values in lists

  • Release version: Australia
  • Updated March 12, 2026
  • 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

    This feature allows users to view default currency values in their session currency, formatted according to their locale. It applies to different field types, including currency and price fields, enhancing usability and clarity in financial data representation within ServiceNow lists.

    Show full answer Show less

    Key Features

    • Currency Field Types:
      • Currency: Displays value in the user's session currency.
      • Price (Calculated): Shows value in the user's session currency.
      • Price (Fixed): Displays the currency value as entered by the user.
      • Price (Multiple): Shows the value in the session currency if it exists; otherwise, it defaults to the first entered value.
    • Globe Icon Functionality: Allows users to toggle between different currency displays, including the value as entered, session currency, and reference currency values.
    • Aggregation Operations: Supports calculating totals, averages, minimums, and maximums on currency columns, displaying the results in the user’s locale.
    • Filtering: Users can filter currency fields by entering a currency code and numeric value, with results displayed based on the reference currency comparison.

    Key Outcomes

    By utilizing these features, ServiceNow customers can expect enhanced clarity and accuracy in financial data representation, improved filtering capabilities, and effective aggregation of currency values. However, be aware of potential discrepancies due to fluctuating conversion rates, particularly with fixed and multiple price types.

    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.