Expand my Community achievements bar.

Issue when using aggregate function

Avatar

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

Avatar

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.