A smarter AVERAGE() and COUNTIF(). - I have an issue where I cannot do a simple AVERAGE() computation.
I have a form where there are 20 number fields and when I do an Average() of all the 20 fields it will average based on 20 values even though I only put numbers on 5 of the fields. I am not sure why this is happening possibly the default value of a number is 0? and this 0 is placed in the field that’s why it gets counted?
Maybe we can have a smarter AVERAGE() function? OR a COUNTIF() function that we can specify to count fields that have values “> 0” . I have checked the docs and appsheet does not seem to have the COUNTIF() function.