how to remove #Error! from matrix report

Question

I have a custom object with a large Matrix report. Everywhere I have blank within the Object the report is showing #.Error!

I want all field to be blank, like the object is properly working.

Anyone have answer? I have looked for answer, but nothing seems to work.

Thx!

John Neilan · Accepted Answer

It's not about the report, it sounds like there's a problem with one of the custom formula fields you have created.  I get that a lot if I divide by 0, but there are other causes as well.  This might help:   https://help.salesforce.com/HTViewHelpDoc?id=fixing_formula_errors.htm&language=en_US

Sunil Sarilla · Answer

+1 John   If its not a formula field on the Object, did you create a custom summary formula field on the report, in either case you have to modify the syntax of your formula.   Please post your formula if you are having difficulty to modify the same.

how to remove #Error! from matrix report

Reports & Dashboards

Aprendizaje relacionado

Más ayuda