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

maheswarik23685
Level 4
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.

1585747_pastedImage_2.png

1585746_pastedImage_1.png

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.

Thanks,

Maheswari

2 Replies
shrawans3153003
Employee
Employee

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.