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.

Try these:=Format(Fields!PercentValue.Value, "p2;(p2)")=Format(Fields!PercentValue.Value * 100, "#.00%;("#.00%)")Chicagoan ...

Do you need the negative sign with the parentheses or did you just want the parentheses? And what version of SRSS are you using?

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~~

I guess they don't want the negative sign. SSRS 2005

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~~

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.

="#,##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! :)