Sum of data show in list of dictionary

Question

Hiii, 
 
 I want to add the Total Cost . It show the data in below format. I am using sum function to add the data but it is not working. 
 List of Dictionary - 7 items

Dictionary

Total_Cost 19000 (Number (Integer))

Dictionary

Total_Cost 18000 (Number (Integer))

Dictionary

Total_Cost 15000 (Number (Integer))

Dictionary

Total_Cost 7000 (Number (Integer))

Dictionary

Total_Cost 9000 (Number (Integer))

Dictionary

Total_Cost 13000 (Number (Integer))

Dictionary

Total_Cost 1500 (Number (Integer))

Mathieu Drouin · Answer

a!localVariables(
 local!dictionary: {
 {
 totalCost: 1000
 },
 {
 totalCost: 2000
 },
 {
 totalCost: 3000
 }
 },
 sum(local!dictionary.totalCost)
)

Stefan Helzle · Answer

This makes your code more readable. 
 
 Did you consider to do that aggregation directly in the query? 
 If this does not work for you, Mathieu Drouin has the solution.

Sum of data show in list of dictionary

Top Replies