| TABLE 1: Calculation Conditions and Format Strings for Decimal-Place Options |
| Calculated Cell |
Description |
Format String |
|
ScaledVal0Decimal |
Measures.[Scale] - ROUND(Measures.[Scale],0) <= .09 |
#,# |
| ScaledVal1Decimal |
Measures.[Scale] - ROUND(Measures.[Scale],0) > .09
And Measures.[Scale] - ROUND(Measures.[Scale],0) < .19 |
#,#.0 |
| ScaledVal2Decimal |
Measures.[Scale] - ROUND(Measures.[Scale],0) >= .19
AND Measures.[Scale] - ROUND(Measures.[Scale],0) < .29 |
#,#.00 |
| ScaledVal3Decimal |
Measures.[Scale] - ROUND(Measures.[Scale],0) >= .29 |
#,#.000 |