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%)