I have two colunms in a form. The first one is suspected and the second is confirmed results:
A B
Predicted Result Confirmed Result
============ =============
Ckbox 1 Ckbox2
Ckbox 3 Ckbox4
Ckbox 5 Ckbox6
Each row of Ckboxes is one classification
If both boxes are checked then that is a 100% prediction
If neither box in a classification is checked that too is 100% prediction
If one box (either A or B) then that is wrong and should be 0%
Ok, now how can I get a total result in terms of a percentage for all classificatons. Example:
"X" means ckbox checked blank = not checked
A B
Predicted Result Confirmed Result
============ =============
Ckbox 1 X Ckbox2 X 100%
Ckbox 3 X Ckbox4 0%
Ckbox 5 Ckbox6 100%
Ckbox 7 Ckbox8 X 0%
-------------
TOTAL 50% overall acurate
I cannot get a TOTAL for all 4 classification. Here is how I am getting the single classification result
=IIf([SusDepr]=Yes And [PosDepr]=Yes,100,IIf([SusDepr]=Yes And [PosDepr]=No,0,IIf([SusDepr]=No And [PosDepr]=Yes,0)))
where SusDepr is ckbox 1 and PosDepr is ckbox 2
Any suggestions,
A B
Predicted Result Confirmed Result
============ =============
Ckbox 1 Ckbox2
Ckbox 3 Ckbox4
Ckbox 5 Ckbox6
Each row of Ckboxes is one classification
If both boxes are checked then that is a 100% prediction
If neither box in a classification is checked that too is 100% prediction
If one box (either A or B) then that is wrong and should be 0%
Ok, now how can I get a total result in terms of a percentage for all classificatons. Example:
"X" means ckbox checked blank = not checked
A B
Predicted Result Confirmed Result
============ =============
Ckbox 1 X Ckbox2 X 100%
Ckbox 3 X Ckbox4 0%
Ckbox 5 Ckbox6 100%
Ckbox 7 Ckbox8 X 0%
-------------
TOTAL 50% overall acurate
I cannot get a TOTAL for all 4 classification. Here is how I am getting the single classification result
=IIf([SusDepr]=Yes And [PosDepr]=Yes,100,IIf([SusDepr]=Yes And [PosDepr]=No,0,IIf([SusDepr]=No And [PosDepr]=Yes,0)))
where SusDepr is ckbox 1 and PosDepr is ckbox 2
Any suggestions,