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
Post a Comment