Setting decimal places on a dimension

[hopkinsc]

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?>

[#2 · Accepted solution]

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,

[#3]

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')

This would solve your problem

[hopkinsc]

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

[#5]

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

[#6]

Hi

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

[hopkinsc]

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

[TS60]

This solution does not work.  I have two calculated dimensions which are formatted as dollars with two decimal places, and they display correctly.  When I add those two dimensions to get a total (as a third dimension), it illogically displays a numeral with eleven decimal places and no dollar sign.