About Precision Settings

In Other Options, you can control data precision by applying minimum and maximum values for different account types. For example, you can truncate and round the decimal portion of longer numbers. Precision settings affect just value display, not their stored values. For example, if Minimum Precision is 2, and the value 100 from Q1 is spread to Jan, Feb, and Mar, the month cells display 33.33 when they are not selected. When selected, they display their actual values (for example, 33.33333333333333). Because the number of decimal places for storing values is finite, when the values for Jan, Feb, and Mar aggregate to Q1, 33.33333333333333 is multiplied by 3, and Q1's value is 99.99999999999998. If you select Use Currency Member Precision Setting, the Currency Values precision settings will be disabled.