Hello out there, I have a matrix field containing a decimal(18,2) value if the value = 0.00 the field has to be cleared = display nothing hope someone can help thanks in advance, Jos van Hertrooij

Hi Jos, Generally, we can use the decision function IIf to achieve this. For example, if originally the value in the data cell of the matrix is =Sum(Fields!Amout.Value), in order to display nothing if the result equals to 0.00, we can change the expression to =IIf(Sum(Fields!Amout.Value)=CDec(0),nothing,Sum(Fields!Amount.Value)) Please change the date field name based on your report. For more information about the IIf function, please refer to the Decision Functions section in the article Expression Examples: http://msdn.microsoft.com/en-us/library/ms157328.aspx If you have any more questions, please feel free to ask. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Tony, I found the answer I had to apply the first funtion on Fields!Amout.Value however Thanks for pointing me in the right direction Regards, Jos van Hertrooij