# Calculate the total error percentage

• Jul 14th 2012, 12:26 PM
raihan26
Calculate the total error percentage
Below it the table which contains Actual Count and Error Count for each ID.

Code:

```    USER_ID    |    Actual_Count    |        Error_Count     -----------+--------------------+---------------------     1345653                    5                                  4     534140349      5                                  0     682527813      4                                  0     687612723      3                                  0     704318001      5                                  4```

So if you look at the above scenario, For this `1345653` ID Out of `5`, it has `4` errors, same with `704318001` ID, out of `5` it has `4` errors. And all other ID's they didn't have any errors as `Error_Count` is `Zero` for them. So in general if I need to calculate what's the total error percentage, then How I will calculate that? Is it possible to calculate the total error percentage?