T O P I C R E V I E W |
vcho |
Posted - 10/02/2014 : 16:30:20 Hi there
This is a newbie question.
I have some reports with some columns displaying varies number of decimal points. How can I format them into 2 decimal points.
I could not find any option to update the existing Measures settings.
Thank you
Vincent |
2 L A T E S T R E P L I E S (Newest First) |
vcho |
Posted - 10/02/2014 : 20:02:48 Great, thank you.
|
admin |
Posted - 10/02/2014 : 19:07:19 If you are talking about an OLAP report, there are two ways to do it.
1. Create a calculated measure that will point to the original measure. For the format pick: #,#.00. You can right click on the column to change the name of the calculated measure to the original measure.
2. Open the SSAS database in BIDS, find the measure, open its properties and change the Format String to: #,##0.00 http://sharepointmike.wordpress.com/2012/06/02/949/
|
|
|