I am creating some calculated fields in a pivot table. This will calculate some historical data, where there are some blanks in the data. This results in a "#DIV/0!" error. So, I changed the formula from " =SumOfSumOfActives/SumOfSumOfTrials " to a fomula using the IF(ISERR function, " =IF(ISERR(SumOfSumOfActives/SumOfSumOfTrials),"-",(SumOfSumOfActives/SumOfSumOfTrials)) ". But now, it gives me the " #VALUE! " error. I think the issue is that this is a numerical field, and if I subsitute the dash in the formula (-) with a zero, it works and shows 0%. The problem that I have is that it is showing 0% for the ones with the error, and also 0% for a few cells where the actual value should be zero. I would prefer to the error outcome be something other than zero. Suggestions anyone?
Thanks!
Bookmarks