4 Replies Latest reply on Jul 7, 2017 3:42 PM by malou.puyod.0

    Weighted Average (error: cannot mix non-aggregate and aggregate)

    malou.puyod.0

      Hi,

       

      I am having an error when trying to create a calculated for Weighted Average.  The error is it cannot mix aggregate and non-aggregate.

       

      Screen Shot 2017-07-08 at 3.37.08 AM.png

       

      I need to get the Weighted Average per Postal Code, State and for GRAND Total.  For the interval column : AVG(Interval) while to get the Order Volume it's COUNTD(Order ID).  The Weighted Average formula I searched from another post is :

      SUM([Frequency]*[Sample Size])/SUM([Sample Size])   so in my scenario I'm trying this SUM (  AVG(Interval) * COUNTD(OrderID)  )   / COUNTD(OrderID) but the error occurred.  Can you please help me how to fix this?

       

      See attached workbook.

       

      Thanks in advance.

       

      Lou