2 Replies Latest reply on Nov 19, 2009 5:32 AM by RobForsyth

    Finding records with discrepant values in three fields

    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