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
Click the + menu icon after the last column header, or open the Column Menu by clicking a column's dropdown icon.
Select Currency and configure the field in the pop-up window.
From Record View
Open a record.
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.