Hide Error Values And Error Indicators

Hide Error Values And Error Indicators Average ratng: 4,7/5 7675 votes
Hide value error in excel

Hide Value Error In Excel

Excel hide error indicators

I have an ssrs report in which i have to calculate percentage iam getting percentage my problem is iam getting #Error if the value is 0/1 i want to replace #Error with 0 i wrote below expression for percentage calculation ((Sum(Sum(Switch(Fields!DataCenter.Value='Revenue',Fields!Amount1.Value))-sum(Fields!Amount.Value))/Sum(Switch(Fields!DataCenter.Value='Revenue',Fields!Amount1.Value))).100)/100 how to achieve that one. I wrote below expression to solve that one.

=IIF((Sum(Sum(Switch(Fields!DataCenter.Value='Revenue',Fields!Amount1.Value))-sum(Fields!Amount.Value))/Sum(Switch(Fields!DataCenter.Value='Revenue',Fields!Amount1.Value)))= 0,0,((Sum(Sum(Switch(Fields!DataCenter.Value='Revenue',Fields!Amount1.Value))-sum(Fields!Amount.Value))/Sum(Switch(Fields!DataCenter.Value='Revenue',Fields!Amount1.Value))).100)/100) but iam unable to remove #Error can any one suggest me how to do this.

Posted on  by  admin