How to show #ERROR as Zero or as Nothing in matrix cell when groups and calculated field in SSRS?

Question

I created a matrix, but there is no data in some cells. If the given cell is just a number, then it is empty. And if there are calculations in the cell, then an #error appears.

Answer 1

I believe the correct solution here is to fix your formula so it handles blanks (or nulls as the case may be). Perhaps something like this.

IIf((IsNothing(SomeField)=True) Or (SomeField = ""), 0, SomeField)

This would check the field to see if it is null or empty (I believe) and return 0 if it is. Otherwise it returns the field value. This would prevent errors but might be more complex if you're using this in a larger expression. At that point you should probably consider adding a field to your dataset to calculate this in advance so you can simplify the row display.

Answer 2

Hi @Кривогорницына Виктория Андреевна

How is your calculations look like ？ when #error appears ，it means there is some error on your expression .

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.