The FX Currency Selector lets you switch the currency displayed in your dashboards at the click of a button — without duplicating widgets or rebuilding your data. Once your tables are configured with Monetary fields, every eligible widget can toggle between your original posting currency and any of your reporting currencies (for example, USD, EUR, or GBP).

Note: This feature is being rolled out gradually. If you don't see the FX selector in your environment, contact your Customer Success Manager to have it enabled for your organization.

How It Works

Datarails distinguishes between two kinds of monetary amounts in your tables:

• Posting Amount — the original transaction amount, in its local (posting) currency. This is the source amount as recorded in your ERP or source system.
• Reporting Amounts — converted amounts, each mapped to a specific reporting currency (e.g., Reporting Amount USD, Reporting Amount EUR). These are typically populated by your FX rate lookups or calculations.

These fields are marked in your tables using the Monetary field designation. On top of them, every table that contains Monetary fields automatically exposes a Reporting Amount field — a system-created, currency-aware placeholder. When you build a widget on Reporting Amount, Datarails resolves its value at runtime according to the currency selected in the FX selector: the posting amount field when None is selected, or the matching reporting amount field when a currency is selected.

Important: a widget follows the currency selector only when its Currency conversion toggle is turned on in the Widget Editor (see Step 3). Widgets with the toggle off, and widgets that use a concrete field directly — the posting amount field or a specific reporting currency field — keep showing their stored values, regardless of the selected currency.

Prerequisites

• FX feature enabled — The FX Currency Selector must be enabled for your organization.
• Monetary fields configured — An admin must tag the relevant fields in your tables (posting amount and one field per reporting currency). See Step 1 below.
• Reporting amount data — The reporting amount fields must contain converted values, for example via your existing FX rates lookup.
• Dashboard permissions — Any user who can view a dashboard can use the currency selector; configuring Monetary fields requires table editing permissions.

Step 1: Define Monetary Fields in Your Tables (Admin)

Before the selector can do anything, Datarails needs to know which fields in your tables are currency-aware.

1. Go to the Tables section and open the relevant table (for example, Financials).
2. Open the field settings for the field that holds your original transaction amounts.
3. In the FX Settings section, set the Currency type to Posting. This field becomes the table's canonical Posting Amount.
4. Next, for each reporting currency you want to support, open the field that holds the converted amounts and set:
   • Currency type — Reporting
   • Currency code — the 3-letter ISO code (e.g., USD, EUR, GBP), or a custom currency label (e.g., USD Budget) for scenario-specific reporting amounts
   • Symbol (optional) — a display symbol such as $ or €
5. Save. Fields tagged this way display a Monetary badge next to their type in the Table Fields screen, and the posting currency field is flagged so you can see at a glance which field is the table's posting currency.

Validation rules to keep in mind:

• Each table can have only one field marked as the Posting Amount.
• Each reporting currency can be mapped to only one field per table. If you try to add a duplicate, you'll see: "There is already a reporting amount with this currency code."
• A currency code is required for every reporting amount field.
• The posting amount field must be numeric.

Step 2: Switch Currencies in the Dashboard

1. Open any dashboard.
2. In the dashboard header bar, find the FX dropdown (located between the Filters and the date picker).
3. Click the dropdown. You'll see:
   • None — widgets show original posting amounts.
   • One entry per configured reporting currency, shown with its symbol (e.g., USD - $, EUR - €, USD Budget - $).
   • A star icon next to each option — the filled star marks your organization's default currency (see "Setting a Default Currency" below).
4. Select a currency. All currency-aware widgets (those with Currency conversion turned on) immediately switch to display values from the matching reporting amount field.
5. To return to original amounts, select None.

The selector opens with your previously saved selection for that dashboard; if you haven't made one yet, it opens with your organization's default currency (see below).

Which Widgets Are Affected

How calculated values behave: conversion happens before calculation. For example, if a widget shows Gross Margin = (Revenue - COGS) / Revenue and you select USD, Revenue and COGS are each resolved in USD first, and only then is the margin computed. This keeps ratios and KPIs consistent across currencies.

Tip: if you want a widget to always show one specific currency — for example, a "Revenue (USD)" KPI that should never change — leave Currency conversion off, or build it on the concrete field (e.g., Reporting Amount USD). The currency selector will leave it untouched.

Step 3: Use the Selector in the Widget Editor

The same FX selector is available in the Widget Editor header, so you can preview a widget in any currency while building it. To make a widget currency-aware:

1. Open the widget for editing. The currency you selected on the dashboard carries over — it is not reset.
2. Add a single Monetary field — typically Reporting Amount — to the widget's Value section.
3. Click the currency icon on the value field and turn on Currency conversion ("Use FX conversion in this widget"). The currency icon fills to show conversion is active; turning the toggle off returns it to its outline appearance.
4. If the value was using a function other than Sum, a confirmation appears: "This value uses [function]. Turning on currency conversion will switch it to Sum. Are you sure you want to make this change?" Click Turn on anyway to proceed. While conversion is on, Sum is the only available function — the other options are disabled with the note "Only Sum is available while currency conversion is on."
5. Use the FX selector in the editor header to preview the widget in different currencies. Build the widget once — the selector determines the displayed currency at runtime, so there is no need for duplicate widgets per currency.

Single-value rule: Currency conversion works only when the Value section holds exactly one field, and that field must be Monetary. Adding any second field — monetary or not — makes the widget non-currency-aware: the toggle is disabled with the warning "Works only when Values has a single monetary field on its own. Remove the other fields to turn it on," and the FX selector in the editor header shows N/A for that widget.

Turning conversion off: with the toggle off, the value stays in its stored currency and no longer follows the FX selector.

Setting a Default Currency (Super Admin)

Your organization can define a Default Currency so that dashboards, Excel workbooks, and builders open with a consistent currency state.

• How it's set — Each option in the FX dropdown has a star icon next to it. A Super Admin clicks the star to make that currency the organization default; the filled star marks the current default. This works from any currency selector in the web app.
• Who can change it — Only Super Admins. For all other users the star control is visible but disabled, with the tooltip: "Only a Super Admin can change the default currency."
• Where it applies — Any currency selector without a previously saved selection opens with the default currency.
• "None" is allowed — The default can also be set to None (posting currency).
• Saved selections win — Saved views, workbooks, and previously generated files that already store a currency selection keep it. The default only applies where no saved state exists.
• Older Excel add-in versions — If a workbook is opened with an add-in version that does not support currency conversion, dr.get formulas and Datarails Excel Tables present values in the default currency.

Saved Views and Persistence

The currency selection behaves like a dashboard filter:

• Per-dashboard memory — your last selected currency is remembered per dashboard and restored when you reopen it (it survives a page refresh). If you have never made a selection on a dashboard, it opens with the organization's default currency.
• Saved views — when you save a dashboard view, the FX selection is saved with it. Loading the view restores the currency.
• Multiple views, multiple currencies — different saved views of the same dashboard can each have a different currency (for example, a "Group USD" view and a "Local EUR" view).

Learn more about saved views in Dashboard Customization.

Currency Selector Beyond Dashboards

The same currency selection experience extends to the other Datarails surfaces where you consume monetary data.

Excel Add-In

Workbooks that use Datarails formulas gain a workbook-level currency selector in the add-in, with the same options as the dashboard (None for posting currency, plus your reporting currencies).

• What it affects — dr.get Formulas and Datarails Excel Tables built on the Reporting Amount field resolve to the selected currency. Excel formulas that consume those outputs (e.g., a Gross Margin calculation) inherit the currency automatically, and drilldowns reflect it as well.
• What it doesn't affect — Manual ranges, static values, formulas that don't depend on dr.get, non-monetary measures (counts, quantities), and flat Datarails tables.
• Templates and refreshable reports — Refresh actions re-evaluate all dr.get formulas using the currently selected currency, with no formula changes needed.
• Split files — As with global filters, the currency selection is locked in split files; recipients cannot change it.
• Older add-in versions — If a workbook is opened with an add-in version that does not support currency conversion, values are presented in the organization's default currency.
• Errors — If a requested currency is not supported by the table, dr.get returns a descriptive error (e.g., #UNSUPPORTED_CURRENCY) with a matching warning in the add-in pane — never a silent zero.

Report & Budget Builder

A Currency selector is available in the builder toolbar whenever the selected function is based on a field defined as a posting currency. The options are None plus the reporting currencies that exist in the table the builder's function is connected to (for example, the currencies in the Financials table).

• Web presentation only — Changing the currency affects the report presentation in the web. Excel files already generated from the builder are not changed retroactively.
• Calculated rows and columns — Arguments are converted to the selected currency first, and the calculation is evaluated afterwards (e.g., for "row 2 / row 3", both rows are converted before dividing).
• Downloads — When you download a report, the Excel file opens with the same currency selected in the Excel currency selector. If the add-in version doesn't support the currency converter, the file opens in the original currency.
• Split budget builders — When a budget builder is split, the currency selection is preserved and the files are created with the selected currency.
• Publishing from Excel — Updating a budget builder from Excel ("Save and publish to Excel") behaves like global filters: it does not change the Excel currency selector.

Troubleshooting

A widget shows "No data available. The selected currency is missing from the table."

Problem: The widget's underlying table does not have a reporting amount field for the currency you selected.

Solution:

• Select a different currency in the FX selector, or select None to show posting amounts.
• To support this currency, ask your admin to add a Monetary reporting field with that currency code to the table (see Step 1) and populate it with converted values.

A widget shows "The posting currency is missing from the table"

Problem: None (posting currency) is selected, but the widget's underlying table does not have a valid Monetary field tagged as the posting amount.

Solution:

• Select a reporting currency in the currency selector, or
• Ask your admin to tag the table's posting amount field as a Monetary field with Currency type = Posting (see Step 1).

The FX selector doesn't appear in my dashboard

Problem: The dropdown is missing from the dashboard header.

Solution:

• The feature may not yet be enabled for your organization — contact your Customer Success Manager.
• Verify that at least one reporting currency has been configured on your tables; the selector's list is built from the currency codes defined across your tables.

A currency I expect is missing from the dropdown

Problem: The FX dropdown doesn't list one of your reporting currencies.

Solution:

• Check that a field with Currency type = Reporting and that currency code exists in the relevant table.
• Make sure the field was saved with a currency code — a 3-letter ISO code (e.g., USD) or a custom currency label (e.g., USD Budget).

Some widgets don't change when I switch currency

Problem: A widget keeps showing the same values regardless of the selected currency.

Solution:

• Open the widget in the Widget Editor and check that Currency conversion is turned on: click the currency icon on the field in the Value section. A widget with the toggle off keeps its stored currency by design — this is how you pin a widget to a fixed currency.
• Currency conversion requires the Value section to hold exactly one Monetary field. If the widget has additional fields in Values, the toggle is disabled and the FX selector shows N/A for that widget — remove the extra fields to enable conversion.
• Counts, quantities, and dimension-only widgets are not currency-aware by design.

The FX selector shows "N/A" in the Widget Editor

Problem: The FX dropdown in the Widget Editor header is disabled and shows N/A.

Solution:

• The widget being edited is not currency-aware. Make sure its Value section holds a single Monetary field and that Currency conversion is turned on (see Step 3).

I can't change the default currency

Problem: The default currency option is greyed out, with the tooltip "Only a Super Admin can change the default currency."

Solution:

• Only Super Admins can change the organization-level default currency. Ask a Super Admin in your organization to update it.
• You can still change the current currency selection for yourself on any dashboard — the default only controls what selectors open with when no saved selection exists.

Frequently Asked Questions

Does switching currency change my underlying data?
No. The switch is visual only — the selector changes which field the widgets read from. Your data, filters, and widget definitions remain unchanged.

Do I need to rebuild my widgets to use this feature?
You build each widget once, with a single Monetary value (typically Reporting Amount) and Currency conversion turned on — that single widget then serves every currency. Existing widgets become currency-aware by turning on Currency conversion in the Widget Editor. This replaces the old approach of building duplicate widgets or dashboards per currency.

Why can I only use Sum when currency conversion is on?
Sum is the only aggregation supported for currency-converted values in this release. Turning on Currency conversion switches the value's function to Sum (after a confirmation), and the other functions stay disabled with the note "Only Sum is available while currency conversion is on." Turn conversion off to use other functions.

Where does the list of currencies come from?
It is the unique list of currency codes defined on Monetary reporting fields across your tables. Adding a new reporting currency to a table adds it to the selector.

How are the converted amounts calculated?
In this release, reporting amount fields hold values you maintain — typically populated through your existing FX rates lookup or calculated columns. The selector reads those fields; it does not calculate rates itself. See Lookups Overview for how FX rate lookups work.

Is my currency selection shared with other users?
Your own last selection is remembered per dashboard for you, and it does not affect other users. What is shared: the organization-level default currency (what selectors open with when no saved selection exists, set by a Super Admin) and any public saved views that include a currency selection.

Is the currency selector available in Excel or the Report Builder?
Yes. The Excel Add-In offers a workbook-level currency selector that drives dr.get formulas and Datarails Excel Tables, and the Report & Budget Builder has a currency selector in its toolbar. See the Currency Selector Beyond Dashboards section above for details. Availability may vary during the gradual rollout.

Updated September 09, 2026 12:18