It's really handy in some cases to Interpret zero as no value - to cover a time period when a certain page didn't even exist for example. But I wish the same logic applied to %s so my YoY numbers would be blank rather than display a useless Infinity%
If you have the right to modify your calculated metric, could you add an IF statement to the calculation? Checking that IF there is a denominator (i.e. not 0) or if the denominator is greater than 0 (this will require a nested greater then function inside the IF), then do the division of your metrics, otherwise return a static value of 0?
Then you could use the "interpret zero as no value" option....
I've not tried this, but it should work?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.