Dears,
I want to run correct calculation of an average.
Example: the average of 1, 2, 0, 4, 5 is =1+2+0+4+5/4=3. Though, in Excel when you highlight 5 columns together the average in bottom will show 2.4 because it is divided by 5 not 4.
Question: is it possible in Kobo to run the calculation where while division “0” should not be counted. Meaning is it possible to do the following
${a}+${b}+${c}+${d}+${e} div “if” or “only” or I don’t know count()
Many thanks,
Amriddin