How does iDBQuery handle multiple currencies in one answer?
iDBQuery reports amounts in the currency stored in your data and, where your organisation has set a reporting currency and exchange rates, can convert and total mixed-currency figures into one. It shows the SQL and cites each source amount, so both the original and converted values stay auditable.
Businesses that sell across borders store amounts in several currencies, and summing them naively is meaningless. iDBQuery keeps currency explicit.
- Native reporting. By default it returns figures in the currency held in the source column, labelled clearly, so "revenue by region" shows each region in its own currency when that's how the data is stored.
- Consolidation. Where your organisation configures a reporting currency and FX rates, iDBQuery can convert and roll everything up into a single total — useful for group-level revenue or spend.
- Formatting. It formats currency using standard ISO codes so €, £, and $ aren't confused.
Because every figure is cited back to its exact source row, you can trace a consolidated total to the original local-currency amounts that fed it, and see which rate was applied. That matters for finance teams who need conversions to be reproducible, not a one-off. If the necessary rates aren't available, iDBQuery keeps values in their native currency and tells you rather than silently mixing them into a wrong total.
Updated 2026-06-22