Treatment of Decimal Changes in Planning Changes

The Format String property for a measure item determines the number of decimal positions that will display in the grid for its values. That format will be applied to values entered or pasted into a planning enabled cell. If a user enters changes with more or less decimal places than those in the format string, values will be rounded to match the format string once the user is done making changes and has pressed the Enter key or clicked anywhere else in the view (or when the Paste has been completed).

In this example, a user entered 100.5 for the plan dollars measure item and the Pear Hlvs product. The format string for the measure item contains zero decimal places.

When the user accepts the change, the value is rounded to 101 based on the measure item format string.