I’ve been working on the BTS Project Tracker dashboard. I’ve found another capability that I needed to learn before I can complete the dashboard. I need to find the average of non-zero values.
I’m trying to track incomplete tasks whose duration exceeds the average duration for that task.
The problem arises when calculating the average interval required to complete each task. I want to exclude any incomplete BTS-task from the calculation of the average interval.
To say that another way, the average interval should be based upon only those sites for which that task is completed already. Continue reading “Find the Average of Non-Zero Values”