Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Rounding to 2 Decimal points		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vcho

New Zealand
2 Posts
Posted - 10/02/2014 :  16:30:20  Show Profile  Reply with Quote
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

admin

1635 Posts
Posted - 10/02/2014 :  19:07:19  Show Profile  Reply with Quote
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/
Go to Top of Page

vcho

New Zealand
2 Posts
Posted - 10/02/2014 :  20:02:48  Show Profile  Reply with Quote
Great, thank you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page