Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Issue when using aggregate function


Level 4

Hi Team,

When I am trying to find F and M value I am facing issues in aggregate functions.

Below is the workflow which I used.



Since it  throwed  above error I tried with group by on primary key.But it was calculating overall sum of  vehicle price.

I need to calculate sum of vehicle price for each customer

Kindly let me know how to calculate sum specific to customer.



2 Replies



Could you please share the screenshot of query and enrichment activity conditions .

Also try to run after enabling the sqllog to see actual query which is being generated.