Hi All,
I am trying to calculate a forecast Bias. I am getting the #DIV/01 if either of the fields is 0 - which in my case will happen often. Is there an a formula you can think of that can calculate the forecast bias if either of the forecast or actual show as 0?
Thanks in advance,
Lee.
Bookmarks