Formatting zero percent (but not 0.1%) as -% (SSRS2008 SP1+bits)


i'm calculating percentages within report, of small, i.e. less 0.5%. i'm displaying whole percentage points small values showing 0%. however, i'd display true 0 values -%, leave small values 0%. there specific format choice this, or have write conditional formula?

e.g. want

1.34572456% displayed 1%

0.32456246% displayed 0%

and

0.00000000% displayed -%

 

thanks help

ray


i work uk time. if post, or another, answers question, please click 'mark answer' button others same problem can find solution more easily.

that's did, thanks.

from responses, i'm assuming answer original questions is, "no, there isn't format option, have write conditional formula."

thanks all

ray


work uk time. if post, or another, answers question, please click 'mark answer' button others same problem can find solution more easily.


SQL Server  >  SQL Server Reporting Services, Power View



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........