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