8 Replies Latest reply on Oct 10, 2018 12:56 PM by Jim Dehner

    LOD expression and averages (distinct ID numbers)

    Diane Vickrey

      Hi,

       

      My data file has wage data by quarter for program graduates, and I've created a calculated field called Annual Earnings that correctly calculates annual earnings: {Fixed [id_number], [wage_yr], [grad_yr], [major_1]: sum(wages)}.The problem is that some individuals earned more than one credential (multiple majors) in a given year, and when I use the average function, it includes the annual earnings more than once for those individuals. I want to average annual earnings by counting an individual's annual earnings only once (not once for each major). I can't attach my file because it contains sensitive data. Any suggestions?

       

      Thanks.