Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Why can't I get the average function work with empty cells?

Elgen55
Level 2
Level 2

Why can't I get the average function work with empty cells?

2 Replies
whyisthisme
Level 7
Level 7

because it is doing a division by 0 which is invalid. Just put in an if statement that only does the calculation is the field is not null.

Elgen55
Level 2
Level 2

The thing that I am having a problem with is that I made a different form that calculates the average no matter how may of the cells have numbers or not and I didn't use an if function.  I have tried with this other form and and it calulates as if all the cells where being used.  I am using the [*] in both instances but it only works in the one I did earlier.