nest IIF for that=IIF((SUM(IIF(Fields!POSITION_DESCR.Value not like "MGR%" Or Fields!POSITION_DESCR.Value not like "SUPV%", Fields!GREEN.Value,0) + Fields!YELLOW.Value + Fields!RED.Value)) = 0, 0, sum(Fields!GREEN.Value) / SUM(IIF(Fields!POSITION_DESCR.Value not like "MGR%" Or Fields!POSITION_DESCR.Value not like "SUPV%", Fields!GREEN.Value,0) + Fields!YELLOW.Value + Fields!RED.Value))
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/