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 |
---|---|
31 | |
11 | |
3 | |
2 | |
2 |