Highlighted

Issue when using aggregate function

maheswarik23685

03-10-2018

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

Replies

Highlighted

shrawans3153003

Employee

03-10-2018

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.