5 Replies Latest reply on Aug 18, 2017 7:56 AM by Jim Dehner

    Find Averages by Excluding Filtered Selection

    Leanne Vermeulen

      I have a dataset with different charges (Base Charges, Total Charges, etc.) and I want to be able to calculate the average of these charges, but only when a condition for another field is not met/by excluding the condition selected in a filter. For example. I have a filter created from a parameter that defines the number of hours assigned to a job. If I choose "8 hours" from the filter, I want to be able to workout the average of Base Pay for jobs where the hours was NOT 8 hours.

       

      I've attached a sample file here.