Skip to main content
Currency Field

Add currency fields to fit any geography

Emma Montgomery avatar
Written by Emma Montgomery
Updated over 2 weeks ago

The Currency field is a numeric field type designed for monetary values, supporting major currencies globally. Use it to track, calculate, and summarize financial data in a format that fits your geography.

Plan Availability

All plan types

Permissions

Solution Manager: Can add, configure, and manage Currency fields

Related Reading

What is the Currency Field?

The Currency field formats numeric values as currency and can be used in calculations like totals, averages, or summaries. It’s compatible with Formula and Rollup fields, making it a versatile tool for financial tracking.


How to Add a Currency Field

From Grid View

  1. Click the + menu icon after the last column header, or open the Column Menu by clicking a column's dropdown icon.

  2. Select Currency and configure the field in the pop-up window.

From Record View

  1. Open a record.

  2. Click the + sign next to an existing field to add a new Currency field below.


Configuring the Currency Field

Key Settings:

  • Select a Currency

    • Solution Managers can choose from major global currencies to standardize financial data across the platform.

  • Precision

    • Define the number of decimal places to display.

    • The default setting is two decimal places (e.g., $1.00).

    • You can adjust the precision according to your financial tracking needs.

  • Thousands and Decimal Separators

    • Choose how large numbers are displayed based on locale settings.

    • Options include:

      • Depends on Member's Locale

      • Custom settings for separators

  • Large Number Abbreviation

    • Abbreviate large numbers for readability.

    • Available options:

      • None (default)

      • K (thousands) (e.g., $1,000 → $1K)

      • M (millions) (e.g., $1,000,000 → $1M)

      • B (billions) (e.g., $1,000,000,000 → $1B)

  • Negative Values

    • Enable or disable negative numbers.

    • Useful for tracking losses, refunds, or financial adjustments.

  • Required Values

    • Mark the field as required to maintain data consistency and ensure that every record includes a currency value.


Practical Scenarios and Use Cases

1. Track Sales Opportunities

Scenario: A sales team tracks the estimated and actual contract values for opportunities.
Solution: Use a Currency field to record the monetary value of each opportunity within the Sales CRM solution.

2. Summarize Account Contract Values

Scenario: An account has multiple associated sales opportunities, each with a recorded contract value.
Solution: Use a Rollup field in the Accounts Table to calculate the total contract value for all linked opportunities. This field would reference a currency field type.

3. Monitor Financial Results

Scenario: A finance team tracks monthly revenue and expenses.
Solution: Configure Currency fields to record values and allow negative entries for expenses.


Why Use the Currency Field?

  • Global Compatibility: Supports all major currencies.

  • Integration: Works seamlessly with Formula and Rollup fields for advanced calculations.

  • Customization: Offers precise control over formatting and data validation.

Did this answer your question?