5 Replies Latest reply on Jan 18, 2016 7:47 PM by Amit_Kumar

    Must appear in the GROUP BY clause or be used in an aggregate function

    Linda Stinson Adobe Employee

      Symptom

      Red blinking outline on Query after adding data and computing an aggregate, e.g. Sum, Count, Max. Display logs shows the journal entry highlighted here:

      Must appear in the GROUP BY.jpg

       

      Underlying cause

      Number of values don't synch up resulting in an error when adding data to the temporary worktable.

       

      Fix

      Edit additional data and (1) Check the Group box for any columns that do not contain aggregates, and (2) Click Advanced parameters and check Group data by the targeting dimension element.

       

      Preventative

      When adding additional data and computed aggregates in a Query, maker sure every column in the worktable is an aggregate or Group by, including the targeting dimension.