Text Form Field Expression - Calculate Average but Ignore '0' or 'N/A'
Good Day All, I am making a Job Review Word form that is based off a numerical ratings system. I would like to take the average of all the numerical ratings, currently =Average(ADP,Fit,TimeAway,Calendar) is working great. (see pic) What I would like to do is calculate the average of the ratings but ignore any values that say 0 or N/A. In excel I would be using the AVERAGEIF function, but I cannot get that to work here. Does anyone have a solution that I am missing?
