MicroStrategy ONE

Integer Constant in Metric

The Integer Constant in Metric property determines whether or not to add a ".0" after the integer. This prevents incorrect integer division, for example, 2/7 = 0. Normally a ".0" is added to an integer constant to have a float division (2.0/7.0 = 0.286). Some databases have trouble with this change, because some database functions only work with integer data types. This property allows you to turn OFF the addition of the ".0" if you have a database that does not properly handle the .0 added after the integer.

Levels at Which You Can Set This

Database instance and metric