I have a Crystal report I am working on which I need to report percentage of times a value is not recorded in a field.
For example, I have a field named, Vehicle ID, and the users are supposed to enter their vehicle ID, if they do not enter a value it defaults to -20, they can also choose -25,
-15, -10, or -5 (all mean something to our agency).
What I need is a way to report the percentage of each entry above so I can identify how close we are adhering to our data entry requirements.
Currently I have written “if” statements for each value above like the one below for each value:
If E02_02 = “-20” then 1
From here I write another formula for the percentage for each value as well.
As you can see, this is not very efficient and I have to do it for every field in a 500 plus field database. Is there a cleaner way to do this without writing 1000+ if statements?
The fields are all strings and I am using Crystal 8.5 on a SQL server.