I have a table with multiple single select columns. Each single select column generates a numerical value, through a switch formula. I want to average the numerical values for each switch formula column. When I average the columns out now, I get back NaN.
Here are examples of my switch formula columns:
Is there a way to do this?