Hide Error Values And Error Indicators
Hide Value Error In Excel
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.