6 Replies Latest reply: Jun 16, 2010 5:16 AM by Chris Hopkins

# Setting decimal places on a dimension

Hi, i need to set a value on a dimention to 2 decimal places. Its easy enough to do on an expression but i can't seem to set it on a dimension. Can anyone help please?>

• ###### Seiing decimal places on a dimension

Hi

Only way I can think of at the moment is to make it a calculated dimension, then use something like:

`=Num(YourValueField,"#,##0.00")`

Good luck,

• ###### Setting decimal places on a dimension

hi,

Add the dimension Age and then select the same and then press EDIT tab once in the tab write the expression

=num ( Age , '0.00')

• ###### Setting decimal places on a dimension

Thanks very much, that worked. How would i get the £ symbol displayed also?

• ###### Setting decimal places on a dimension

Use this formula instead = money ( Age , '£#,#0.00')

• ###### Setting decimal places on a dimension

Hi

Simple, change the expression to Num( Age , '£0.00')

• ###### Setting decimal places on a dimension

Excellent, thats worked great. thanks for your help everyone...