1 2 3 4 Previous Next 45 Replies Latest reply on Mar 7, 2014 1:38 PM by KevinSiddons

    Counting field values in a Layout form

    KevinSiddons

      Title

      Counting field values in a Layout form

      Post

           Thanks in advance for your help.

            

           I'm in the process of creating a form for summarizing Cause of Death health data. This is a yearly dataset of people who died in a given location.

           Each record has the individual's COD (Cause of Death). I've created a lookup table that links the individual's COD code the seven levels of categories. Level 1 is the most general set of categories; level 7 shows if the COD was drug-induced.

           my Layout successfully counts the number of COD codes within each Level 1 category. What I want to add is the count of drug-induced CODs (Level 7 data) per Level 1 category.

            

           For example, in the category 'Externally Caused COD' (Level 1), how many are drug-induced (level 7).

            

           any help appreciated.

            

           thanks,

            

           Kevin 

        1 2 3 4 Previous Next