Calculate the average of values across several columns in same row?
For each observation (row), I am trying to add a calculated column that displays the average across seven columns and I am stuck. I guess what I am looking for is a "row average" that will ignore null values. Here's the structure:
For the first observation, PCODE 8411, the average of these seven columns, ignoring null values, is [(1+4+1+1)/4] = 1.75.
There are approximately 30 columns, so I only want to average these seven.