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?>
Only way I can think of at the moment is to make it a calculated dimension, then use something like:
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
Thanks very much, that worked. How would i get the £ symbol displayed also?
Use this formula instead = money ( Age , '£#,#0.00')
Simple, change the expression to Num( Age , '£0.00')
Excellent, thats worked great. thanks for your help everyone...
Retrieving data ...