Solved

How do I dynamically change how a percentage is displayed?

Posted on 2011-09-20
2
252 Views
Last Modified: 2012-05-12
I am looking for an expression to change how percentages are displayed. Essentially if the numbers to the right of the decimal end in zero, lop off the zero. example...

100.0000% becomes 100%
99.6230% becomes 99.623%
99.5800% becomes 99.58%

Current format is p4

Expression is..
=iif(Fields!month2.Value = 0,"*",
iif(Fields!month2.Value = 1,"100%",Fields!month2.Value))
0
Comment
Question by:xtrout
2 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 250 total points
ID: 36569780
Use this type of code in your expressions (Formating)

=iif(Fields!month2.Value = 0,"*",
iif(Fields!month2.Value = 1,"100%",Format(Fields!month2.Value, "###.######%")))
0
 

Author Closing Comment

by:xtrout
ID: 36569997
Perfect. thanks so much. I  was wracking my brain.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Locating SQL Data Tools 2012 11 40
Data source in SSRS 2 50
SCCM Reporting 5 55
Textboxes line spacing 6 34
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now