Have you tried turning it off and on again? Hahaha, just kidding. It's bizarre that this is working for your dummy data but not your real data.
From what you're describing, I would have expected that Column C would be calculated:
SUM([EARLY]) / COUNT([number of records])
Is there any chance your formula is first calculating something at the row level, and then aggregating the results of the row level calculations. Rather than first aggregating each column, and then dividing the aggregations? I tried to mock this idea up in Excel. Can you see the difference I mean?
Not sure this has anything to do with your issue, but thought I'd share.
Thanks for the response, Jennifer. Funnily enough, the first thing I tried was closing the program and reopening it, didn't work though. However, I just left it alone for two hours and figured I'd give it one last try before going home and for some reason it worked. As best I can tell, I did the exact same thing I had been doing. I'm just going to chalk this one up to gremlins and move on I guess!
Haha, Gremlins for the win.
Glad it worked out,