2 Replies Latest reply on Aug 20, 2018 11:27 AM by Joshua Thomas

    Ratio of measures

    Joshua Thomas

      Hello.  Beginner here.

       

      I have a measure (# of fatalities) for which I would like to compare against another measure (# of total incidents - 1 incident = 1 record in data set) for given dimensions.  When I create a calculated field of SUM([FATALITIES])/Sum([Number of Records]), however, it just returns the same total number of fatalities no matter what dimension I put in and no matter how many fatalities and numbers of records exist given that dimension.

       

      I am missing something very basic here.

       

      Any help would be appreciated.]

       

      JT