Hey Mark, I'm getting the error that I can not use the <> operator with numbers or text.Also, I am using one Field for each graded question, so I am not sure how to manipulate what I am trying to do with your solution.For example, I will pretend I have the three questions:Wall Cleanliness: (1-10 numeric grade)Floor Cleanliness: (1-10 numeric grade)Window Cleanliness: (1-10 numeric grade)Normally, I'd take the three grades and average them for the overall 'cleanliness' score. But if the next location I go to does not have windows, I would need to omit that from the overall average of the 'cleanliness' score.
A consultant will be physically on site to conduct the assessment, so if he arrives and the location has no windows, he'd select "N/A" for the grade of that field. Not sure if you saw my reply to myself, but I was able to use your code and make it work. This is an example of what I did for one category:var number blank = ToNumber("N/A");
Average(If([Signage Lit / Easily Viewable Day & Night]<>$blank,[Signage Lit / Easily Viewable Day & Night]),If([Reader Board Working]<>$blank,[Reader Board Working]),If([Entrance / Exit Obvious and Easily Understood]<>$blank,[Entrance / Exit Obvious and Easily Understood]))Thank you for your help!