Hoping somone can help, I feel like this should be so simple......
I have a column I want to average, there are 3 scores possible in the column:
The N/A is null so if this is selected it should be removed from the average, the " 0 " should be calculated in the average when selected.
Currently I have the N/A being counted as null, however, "0" is not being considered.
I want to be able to include the " 0 " in the average and keep the N/A as null when selected.
The current formula I am using (which appeared to be working Friday and no longer worked as of yesterday)
avg(If(01,02,03,04,05,06,07,8, '<>N/A' ))
Deadline has been missed due to this, so any help is GREATLY appreciated!!!
Thanks so much!
One way to accomplish this is with a site workflow. I am assuming a couple of things: the Score column is a choice field with 3 choices (100, 0, N/A) and each item in the list has only one score. Here are the steps:
Below is an image of the workflow design: