So I have been trying to figure this out for awhile now:

I have two numbers I am trying to divide to get a decimal i can then turn into a percentage. The numbers are my Total Units and Total Units with CC Defects. For whatever reason these numbers don’t look right. I have maybe 350 units recorded right now.

The daily numbers will come out fine, and I don’t understand that, the percentages look sound. Any ideas here? One persons cell for the FPY comes back as a “infinite” number.

And yes, I’ve reversed the order that they are divided into each other.

EDIT:

Here is what I have come up with, if any can let me know why the percentages are coming out good when I subtract 1 from the entire formula that would be awesome. Right now it looks like I have it figured out but am just confused as to how I really fixed it. Why is it working like that?

Here is two screenshots of the formulas before and after. It looks like I was getting the percentage of the failed units, when I wanted the percentage of all the good units, but why subtracting 1 from that would it correct I don’t know.

Formula 1:

Formula 2: (I subtracted 1 from the entire formula)

EDIT: “JK” and " JVT" Will show a error in the formula because they are not under “CC”, this would be normal.