Multiple currency values

Multiple currency values are amounts that return values in different currencies, like dollars and British pounds.

This table shows which measures and basic operators you can use with measures that return multiple currency values.

Data Type	Plus (+) Minus (-)	Multiplied by (*)	Divided by (/)
Numeric values	-
Single currency values		-	-
Duration values	-	-	-
Multiple currency values		-	-

Note:

If the calculation that you want to use is not supported for multiple currency values but is supported for single currency values, consider consolidating or converting the selected field to a single currency field. For more information, see Currency Consolidation in Workbook.

Returned values for multiple currency calculations

The results that you obtain depend on how the measure definition is built:

• Calculations with numeric values - When multiple currency values are multiplied by numeric values, the calculation returns a result for each currency. For example, if a field with the numeric value 100 is multiplied by a field with the multiple currency values 10 USD and 20 EUR, the calculation returns a result for each currency: 1000 USD and 2000 EUR.

  1000 USD = 100 * 10 USD

  2000 EUR = 100 * 20 EUR

  Note:

  This also applies to multiple currency values divided by numeric values.

• Calculations with single currency values - When you use multiple currency values and single currency values in a measure definition, the calculation only returns a result for the values that share the same currency. For example, a field with the multiple currency values 100 USD and 200 EUR plus a field with the single currency value 20 EUR returns 100 USD and 220 EUR.

  100 USD = 100 USD

  220 EUR = 200 EUR + 20 EUR

  Note:

  This also applies when you calculate multiple currency values minus single currency values.

Related Topics

• Supported Calculations
• Numeric values
• Single currency values
• Duration values

General Notices