ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Rounding to 2 Decimal points

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

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/

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page