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.
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.