I have data as follows:
The table has aliases for the labels. Each equates to:
To keep the table display simple, I filtered to one project only. I see the same results when viewing all projects.
My table looks like:
The Number of Events and Number of Events with Species Classification are both correct. The last two columns are my two attempts at calculating what percent of events have been calculated. What I want is a calculation that would produce the result 414/150094 which equals 0.002758 and would ideally display as 0.28%.
Again, the two formulas I tried are...