Measure Showing multiple decimal places 1

[M8tt]

Hi,

I have a measure coming from a database field with the data type decimal(18,2), in AS the field is AggregateFunction = Sum and DataType = Double.

When I look at the aggregated values some have the 2 decimal places I would expect to see but others go to 6 decimal places. This is not consistent with what the database shows.

Could anyone help in explaining why this might be happening? and how I can get around it.

Many Thanks, Matt

 

[MDXer]

set your format string to #,#.00

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[M8tt]

Thanks very much Paul, that has been irritating me for the past week!