AnsweredAssumed Answered

Finding records with discrepant values in three fields

Question asked by RobForsyth on Nov 19, 2009
Latest reply on Nov 19, 2009 by RobForsyth

Title

Finding records with discrepant values in three fields

Post

I'd appreciate help for a beginner (FMPro 10 on Mac OS X Leopard)

 

This is a project where records are coded (by humans!) according to the data in multiple other fields. Observer 1 has summarised the characteristics of each record (as he sees them) in three additional radio button fields on the record (property 1, property 2, property 3). To check inter-rater reliability Observers 2 and 3 have each replicated the exercise, using different layouts where they can't see other observers' scorings.

 

I now want to pull out the records where any of these ratings (for properties 1, 2 and 3) differ between observers, i.e.

 

 find all records then

 omit records where (property 1 rated by observer 1 = property 1 rated by observer 2 = property 1 rated by observer 3)

   AND  (property 2 rated by observer 1 = property 2 rated by observer 2 = property 2 rated by observer 3)

        AND (property 3 rated by observer 3 = property 3 rated by observer 2 = property 3 rated by observer 3) 

 

so that we can look at where our ratings have differed.

 

I'm getting in a bit of a tangle with this and would appreciate help.

 

Rob 

Outcomes