Forum Discussion
Computing Percentage Test Results (String) for a Certain Application (Category)
Hello, I am looking to create a Table where I have mulitple different web apps that I support that contains a column that shows the results of a security scan as a string value of Pass or Fail. T...
Anonymous you are complicating the calculations, how you are getting to that % you are looking for.
In the first column, I am turning the String Value Pass into a number (1) and if the string value does not equal Pass, I am putting 0 in the row value.
Then I am taking a SUM of the column, so it is adding up all the 1's.
Then I am dividing that sum by the count of total rows in the column:
| Pass/Fail | 1 if Pass, 0 if fail |
| Pass | 1 |
| Fail | 0 |
| Pass | 1 |
So in this example, I would have 2 passes and 3 total rows. So the calculation would be 2/3 (66%)