MicroStrategy ONE

Integer Constant in Metric

This setting determines whether to add a ".0" after an integer (a whole number). This prevents imprecise rounding when division is performed. For example, 2/7 returns the integer 0 if ".0" has not been added. Generally, the ".0" is added, so that the same calculation returns a more accurate result, for example, 2.0/7.0 = 0.3. The use of ".0" is usual.

Some databases have trouble with this change because certain database functions only work with integer data types. Therefore this setting is offered so you can disable the addition of the ".0".

The options for this property are as follows:

  • Add ".0" to integer constants in metric expressions
  • Do not add ".0" to integer constants in metric expressions
  • Use default inherited value