Average issue (super simple for pros i think)

[NoobStarter]

Issue is “Average” doesnt work for numbers
for example average for:
4
4
gives average 2, but it should be 4…

[Marc_Dillon · Accepted solution]

Seems to work fine here. You’ll have to further describe your issue if you’re seeing different.

[Steve]

For reference:

help.appsheet.com

AVERAGE()

Arithmetic average of list items

help.appsheet.com

LIST()

New list

[NoobStarter]

Still issue:
I think its counting empty cells as 0.
Hove i can skip / not take empty cells to average output? I mean if i have for exmpl 3 rows
2
Empty cell
3
Id like to have result 2,5 without 0 on row 2…

[Steve]

Please post a screenshot of the complete expression you’re using.

[NoobStarter]

So its just simple chart, no expressions yet.
Problem is when i add those 4 and 3 numbers i should get 3,5 average, but now its counting empty cels as zero, i think, so average its lover and lover every time empty celss appear. Because students dont haveto add numbers every time…so i think it should have something like “countifnotblank” like expressioins…

[Marc_Dillon]

I suggest making a Slice for only those records with values, then basing the Chart View on that Slice.