Highlighted

Issue when using aggregate function

Avatar

Avatar

maheswarik23685

Avatar

maheswarik23685

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

Avatar

Avatar

shrawans3153003

Employee

Avatar

shrawans3153003

Employee

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.

Highlighted

Avatar

Avatar

kavinkr28

Avatar

kavinkr28

kavinkr28

03-10-2018

Hi kindly find the workflow details,

1.JPG2.JPG3.JPG4.JPG5.JPG

6.JPG