2 Replies Latest reply on Sep 20, 2018 12:43 PM by Deepak Rai

    Isolate by Condition

    Mishal Shahbaz

      I am struggling to write a calculated field to do the follow:

       

      I have survey data that I had to pivot. There were 17 "Mission Categories" that a respondent could answer average mission they conducted in each category. My survey exported this data as columns for each mission category and I pivoted the data. This question was asking for average however some people misinterpreted and gave totals.

       

       

      I am now trying to isolate those folks who answered >= 400 missions for any of the categories.

       

      So for EVERY respondent ID AND EVERY "Mission Category" type, I need to determine when "Mission Category Measure" >= 500 for that respondent and that category type. Then instead of multiplying by # of aircraft for those respondents, I will divide by aircraft.

       

       

      Thank you for your help!