1 Reply Latest reply on Dec 19, 2012 3:37 PM by donna trinh

    I am trying to do some weighting calculations but am running into the Aggregate / Non-aggregate error and do not know how to resolve it.

    Keith Rietz
    Keith Rietz Dec 19, 2012 7:45 AM

      I am new to Tableau and am trying to multiply Booked_Qty times  Forecast Error % to get a weighted quantity.  I think the Booked_Qty is aggregated and the Forecast Error % calculated field is non-aggregated.  I am getting the "cannot mix aggregate and non-aggregate arguments to function." error.  The basic formula logic is:

       

      ([Booked_Qty] * [Forecast Error])  

       

      Please see attachment.

       

      Help?!