In a SharePoint list, I have 6 numeric columns that can contain numbers in the range (1,4). However, one or all of these columns may contain "NA"
value.
There is a separate calculated column which contains the rounded average of the above 6 column values. The issue is -
1) The numeric columns does not allow any "NA"/"NULL"/"#N/A"
value to be entered, so I cannot indicate to SharePoint that that particular value should not be included in the calculation.
2) If one of the numeric column values has NA, then I am forced to leave it as blank. But SharePoint includes this column to calculate average. For example, in this case, the AVERAGE()
formula should consider only 5 columns instead of 6 columns.
Because of this, my resulting average value sometimes does not match the expected result.
Is there any way I can solve this issue?