Hi,
My data is like below. I need to calculate the average like below
1. All True/Total numbers.. I am expecting answer for this 2/4 =0.5
2. All true/Total Critical numbers etc....Answer should be like 1/1 .Can anyone help on this? Thanks!
| Number | Status | Concdition |
| A | Critical | TRUE |
| A | Critical | TRUE |
| A | Critical | TRUE |
| B | High | FALSE |
| B | High | FALSE |
| B | High | FALSE |
| C | Medium | TRUE |
| C | Medium | TRUE |
| C | Medium | TRUE |
| D | Low | FALSE |
| D | Low | FALSE |
| D | Low | FALSE |
