4 Replies Latest reply on Apr 27, 2017 8:15 AM by Deepak Rai

    Average filtered data; return one value

    TerryLynn Delaney

      Hi Everyone.  I need to be able to select several values in a filter and have one output that averages the values selected.  I know there is a calculation in play, but just not sure where to go with it.

       

      For Example:

      There are 20 total System line items so if I selected Alcor and Grayson in the filter, I would need the average to show 45% (9/20).  If I selected Marksup and Alcor and Delinial, the average will show 70% (14/20).

      System         

      Alcor  

      Alcor

      Alcor

      Grayson

      Grayson

      Grayson

      Grayson

      Grayson

      Grayson

      Marksup

      Marksup

      Marksup

      Marksup

      Marksup

      Marksup

      Marksup

      Marksup

      Delinial

      Delinial

      Delinial

       

      Any ideas?

       

      Thanx!