Im colouring the background of a cell if it matches the following criteria, but as Im using a table to show my results.. I cant seem to get the Inscope function working, does the Inscope function on work on Matrix instead of Tables? =iif(inscope("Dept") ,iif(sum(Fields!ID10_Days_Unfinished.Value)/(sum(Fields!within_21_days.Value)+sum(Fields!over_21_days.Value))>= "0.80", "#CCFFCC" , iif(sum(Fields!ID10_Days_Unfinished.Value)/(sum(Fields!within_21_days.Value)+sum(Fields!over_21_days.Value))<"0.70", "#FF8080" , "#FFFF99")) ) Firstly the above code is not being generated correctly (red underline) and secondly am I doing this the correct way?

any help guys

Hi Sam233, Firstly, the InScope function can be used in matrix as said in the MSDN article, the InScope function is useful in data regions that have dynamic scoping, such as a matrix. For more information about InScope function, please see: http://msdn.microsoft.com/en-us/library/ms156490(v=sql.90).aspx Then you expression is not correctly for the reason that you miss a part of the outset IIF function. Please change it like below. =iif(inscope("Dept") ,iif(sum(Fields!ID10_Days_Unfinished.Value)/(sum(Fields!within_21_days.Value)+sum(Fields!over_21_days.Value))>= "0.80", "#CCFFCC" , iif(sum(Fields!ID10_Days_Unfinished.Value)/(sum(Fields!within_21_days.Value)+sum(Fields!over_21_days.Value))<"0.70","#FF8080", "#FFFF99")) ,OtherColor) If you have any questions, please feel free to ask. Regards, Charlie LiaoCharlie Liao TechNet Community Support

Just to clarify, can the INSCOPE function only works for MATRIX's and not on a table.... Because I'm using a table and want to use a similar function

Hi Sam233, Yes, the INSCOPE function works for both matrix and table. Regards, Charlie LiaoCharlie Liao TechNet Community Support