Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2009-05-12 : 04:21:57
|
| Good day, I have an calculated member, with fomrat string being "Percent"([Measures].[Annual GP]/[Measures].[Pay Scale Position1]) * 100it returns the value: 3258.48%and i want to return the value: 32.6%I would like to round and assign decimal place.Please Assist,Regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-13 : 11:05:32
|
| give format expression as ="##.0%" |
 |
|
|
|
|
|
SSAS calculation round and assign decimal places