Hi,
I would like to compare column A and column B and calculate how much % B is of A.
So I added column C with formula "=B/A"
However some of the values in A and B are 0, which result in a statement "Not a number" in column C.
Unfortunately pivot tables can't handle this as a value.
So I...