Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session

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

Avatar

Level 2

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

2 Replies

Avatar

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.

Avatar

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.