6 Replies Latest reply: Jan 29, 2018 3:08 PM by David Forest RSS

    sum of total sales based on values below an average % range

    Andy Cosgrove

      Hi All.

       

      I need a KPI to sum the total sales below 25% of the average sales. The average sales % calculates as follows

      avg(sales)/avg(total sales).

       

      for example if my sales average is 100 I need to sum up all the vales below 25

       

      I'm sure it's a aggr function but I can't get it to work

       

      Thanks in advance