Currency Consolidation in Workbook
Currency consolidation in Workbook combines a field's values into the currency of the lowest-level subsidiary that's a common parent to all the subsidiaries you have access to. The rate type used for consolidation comes from the general rate type set up for each account in your chart of accounts: Historical, Average, or Current. This matches the Per-Account option for exchange rates in transaction saved searches. For more information, see Consolidated Exchange Rate Types for Transaction Searches.
In Workbook, if Current is selected for an account, you can't pick the exact period or date for the exchange rate. The rate is based on when you run the workbook visualization that contains the field. For more information, see Consolidated Exchange Rates.
In Workbook, you can only use currency consolidation on amount fields from the transaction accounting line record type. Like saved searches and reports, you can only use consolidation if you're in a NetSuite OneWorld account with several subsidiaries. To make sure the right rates are used for consolidation, check that your chart of accounts and consolidated exchange rates are set up correctly. You should also check that your currency exchange rates are set up right, since they're part of some consolidated exchange rate calculations. For more information about currency exchange rates, see the Currency Exchange Rates List Page.