SSRS parenthesis around negative values
Group, Still new to SSRS and expressions... however, this should be an easy one I would think. I have a column that is formated as a percent. Some values are negative -.56% . All I want to do is put () around anything that comes up negative (.56%). I guess that is the accounting format for negatives.I tried =iif(Fields!PercentValue.Value <0, "("+Fields!PercentValue.Value+")")maybe something with =format(Thanks in advance for assistance.
April 28th, 2009 10:45pm
Try these:=Format(Fields!PercentValue.Value, "p2;(p2)")=Format(Fields!PercentValue.Value * 100, "#.00%;("#.00%)")Chicagoan ...
April 28th, 2009 10:52pm
Do you need the negative sign with the parentheses or did you just want the parentheses? And what version of SRSS are you using?
April 28th, 2009 10:55pm
Use this in format tab as expression =iif( Fields!PercentValue.Value >0,"N","(#)") . Also use simple Fields!PercentValue.Value in the expression of textbox ~~ Mark it as Answer if you find it correct~~
April 28th, 2009 11:01pm
I guess they don't want the negative sign. SSRS 2005
April 28th, 2009 11:02pm
okie use this:- Use this in format tab as expression =iif( Fields!PercentValue.Value >0,"N","(#)") . in the texbox use this =abs(Fields!PercentValue.Valu e)~~ Mark it as Answer if you find it correct~~
April 28th, 2009 11:10pm
Hi guys, it turns out that you can do formatting in the tab #,##0.00;(#,##0.00) the left side of the semicolon will format a positive value, and to the right of the semicolon will format the negative value. no need to do anything with abs value.
June 17th, 2009 6:42pm
="#,##0;(#,##0)" this works fine in ssrs 2005.. no conditions needed.. its simple .. hope it saves somebody time Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
March 24th, 2011 10:30am