Forum Discussion
IFERROR Problem
Formula is very simple it is a sum of variables and then multiplies by a ratio I have this meausure to compute Total Rev. I am using the IFERROR to counter NAN problem in the calculation. Howeve...
instead of IFERROR use DIVIDE - it handles these scenarios gracefully.
Yes i figured it on my own as well after only an hour after posting the problem. Divide works great for this problem.