Hi, I need to conditional format the expression below to RED IFF the value is greater than 0 or BLACk if the value is 0. =FORMAT(IIF(Sum(Fields!RevisitsCount.Value) > 0, Sum(Fields!RevisitsCount.Value) / IIF(Sum(Fields!TotalSrvCalls.Value) > 0, Sum(Fields!TotalSrvCalls.Value), Sum(Fields!RevisitsCount.Value) / Sum(Fields!TotalSrvCalls.Value) ), 0), "N2") Thanks for your help. Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

Hi, For conditionally formatting your cell in the SSRS report, 1) Select the cell on which you want the formatting to be applied. 2) Go to font, select the fx (expression) 3) In the expression write the following: = Switch( Sum(Fields!RevisitsCount.Value)>0, "Red", Sum(Fields!RevisitsCount.Value)=0,"Black") 4) Click Ok And you are good to go then. Regards, Manoj *Happy to help http://experiencingmsbi.blogspot.com/

Hi Francis, In your scenario, the value of expression is when Sum(Fields!RevisitsCount.Value)>0 AND Sum(Fields!TotalSrvCalls.Value)>0, the result is Sum(Fields!RevisitsCount.Value)/ Sum(Fields!TotalSrvCalls.Value). It is greater than 0, because both of them is greater than 0.When Sum(Fields!RevisitsCount.Value)>0 AND Sum(Fields!TotalSrvCalls.Value)<0, the result is Sum(Fields!TotalSrvCalls.Value). It is less than 0.When Sum(Fields!RevisitsCount.Value)<0, the result is 0 no matter Sum(Fields!TotalSrvCalls.Value) is greater than 0 or less than 0. So if you need to conditional format the expression below to RED IFF the value is greater than 0 or BLACK if the value is 0, then the expression would be like below. =IIF(Sum(Fields!RevisitsCount.Value)>0 AND Sum(Fields!TotalSrvCalls.Value)>0,RED,BLACK) If you have any questions, please feel free to ask. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Manoj, I don't see where the font fx expression takes such an expression. Also your instructions dont say which font fx expression as there are several and they all can't take the conditional formatting. Thanks,Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

Hi Francis, 1. With the expression selected, right-click it and then select Placeholder Properties. 2. Click Font tab in the left pane. 3. Click the fx button, and then type in the expression. The screenshots below are for your reference. If you have any questions, please feel free to ask. Regards, Charlie Liao

Hi Francis, 1. With the expression selected, right-click it and then select Placeholder Properties. 2. Click Font tab in the left pane. 3. Click the fx button, and then type in the expression. The screenshots below are for your reference. If you have any questions, please feel free to ask. Regards, Charlie Liao

Thanks guys - exactly what I needed.Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends