set analysis - producing error rate % on gauge

[124psu]

I created a gauge to show the true error percentage. Employees are supposed to withhold 100% of the money in a system when clients are requesting a withdrawal from their bank account. But employees are not necessarily capturing this data and sometimes forget to enter that amount which doesn't freeze/hold that amount in the system. 

So I created a gauge to show the error percentage rate to see how efficient the employees are capturing this data. 

=(count({<[clientWithdrawal] = {0}>} [clientAccounts])) / (count([clientAccounts]))

When no value has been entered it will automatically be pushed as a '0' 

So I want to count the client accounts with withdrawal amounts that are = 0 and divide that by the total client accounts existing. When I compare the results from the gauge and a simple check through excel I am getting 2 totally different numbers. My set expression looks correct, but hoping something is wrong at this point.

[JordyWegman]

Hi,

Try this:

=count({<[clientWithdrawal] = {0}>} [clientAccounts]) / count(Total [clientAccounts])

With the TOTAL qualifier you get all the clientAccounts.

Jordy

Climber