Must appear in the GROUP BY clause or be used in an aggregate function | Community
Skip to main content
Linda_Stinson
Linda_Stinson
Employee
Jan 16, 2015 7:41 PM UTC

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

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:

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

5 replies

Amit_Kumar
Amit_Kumar
Level 10
Dec 16, 2015 1:43 AM UTC

I am getting a postgreSQL error while updating the schema which contains aggregate function sum.

Translate
Linda_Stinson
Linda_StinsonAuthor
Employee
Dec 18, 2015 5:01 PM UTC

Hi Amit, you need to click on the Advanced link when editing the additional data and activate the checkbox to Group by the targeting dimension.

Linda

Translate
Amit_Kumar
Amit_Kumar
Level 10
Dec 20, 2015 10:46 PM UTC

Hi Linda,

I am using a preloading in web form.so in there i don't see any

checkbox to Group by the targeting dimension.

Regards,

Amit

Translate
Terms & ConditionsAccessibility statement

Loading footer...