I have created a Scorecard table called "Data Entry" which is calculating the average of Four (4) columns which are "[Customer Engagement]", "[Issue Resolution]" ,"[Process Compliance]","[Customer Handling]"
I am trying to modify the App-sheet formula in such a way, that if I do not select a value for any column, I still get the overall average for the Table.
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |