Calculate average of rounded columns
Calculate average of rounded columns
![islamelshobokshy](https://secure.gravatar.com/avatar/61c44b8539ec4778cd9407d1516b5664/?default=https%3A%2F%2Fvanillicon.com%2F61c44b8539ec4778cd9407d1516b5664_200.png&rating=g&size=120)
How can I calculate the average of columns that are shown like this :
98.50 %
99.39 %
78.30 %
84.98 %
Any ideas? I'll have to format the numbers, and then use the average function on it, but I have yet to find a method
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
You can use the
average()
plugin. You'll reformat the numbers but that'll be trivial.Cheers,
Colin