Numeric Value for Multi-Select Text Field Items

Neal,
Why are you using a multi select field. Is it possible for a file to be compliant and not compliant at the same time ?

You want to use Quickbase to error proof the data entry. 

Here is what I would suggest :  Create two multple choice fields  - File Compliance, Scan Compliance. Provide 3 choices - Compliant, Not Compliant, NA. Then use a 3rd field using a case statement such as : 


formula numeric field - Percent Compliant

var num maxScore = case([File Compliance],
"NA",0,1) + 
case([Scan Compliance], 
"NA",0,1) ;

var num actualScore = case([File Compliance], 
"Compliant",1,0) +  
case([Scan Compliance], 
"Compliant",1,0)  ; 


$actualScore / $maxScore