Numeric values

In calculated measures, numeric values are percentages, integers, or floats. They don't return currency results.

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

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

Note:

If the calculation you want isn't supported for multiple currency values but works for single currency, try consolidating or converting the field to a single currency field. For more information, see Currency Consolidation in Workbook.

Returned format for percentage values

When you combine percentage values with integers or floats in your calculation, the result shows up as a decimal value.

For example, if a field with the percentage value 200% is divided by the integer value 10, the operation calculates 2.0 divided by 10. Therefore, the result returns the decimal value 0.2.

0.2 = 2.0 / 10

Note:

The result that you obtain isn't a percentage value. The decimal value 0.2 is the same as 20%. If you'd rather see results as percentages in your pivot tables and charts, you can change the format to percentages. For more information see, Pivot Table Customization.

Related Topics

• Supported Calculations
• Single currency values
• Multiple currency values
• Duration values

General Notices