Average Vs AverageA

What is likely happening here is that your field is formatted as Text. AVERAGE is going to cause an error because it only handles numeric values. AVERAGEA is apparently not living up to its documentation. I removed all of the text values except the numeric text values it and it still gives an average of 0. Soooo...that should not be happening according to the documentation. By the way, I am thinking that your TRUE and FALSE values in a text field would both be counted as 0 (non-numeric text) versus 1 and 0. But who knows because non of it seems to be working correctly.