Hi Yogeshwar,
Which retrieval action you are talking about and which sum activity you are talking about
Are you talking about the DealList if yes your list is empty then your sum will return zero
Also, for which list are you trying to find the sum?
As per your screenshot, you are trying to find the sum of the amount attribute from the CloseDealListQ1 List variable
If yes , can you make sure whether your list as values , from your screenshot I am not able to find the list named CloseDealListQ1
Hello Yogeshwar Polawar,
First thing to know is that, Mendix optimizes the two action retrieve from database and aggregate function into just returning the aggregate function.
If you want to have the list still to fully retrieved then just add an action that uses the list later in the microflow a filter or something.
I think that the list is empty so probably the problem is in your xpath restriction.
Hope this helps,
Good Luck
documentation about the optimization:
https://docs.mendix.com/refguide9/aggregate-list/