I have a list with a number of entries. The quantity of these may change. The list has a % complete. I want to total all the %Completes and provide average. I tried Total in Data view, but when I switch to Standard view a Total line appears with average, this is placed in the wrong location of page and is formatted with large decimal places.
eventually i want to grab this data and display it in a CQWP. So thought I'd create a new list to store the average. Then run a wf on the orginal list to calculate the average.
I've looked at SPD but cant figure out how to count every item in list and lookup % Complete to work out average.
Any help always appreciated.