Sum of data show in list of dictionary

pranavk513816 said:

but it is not working.

What exactly does this mean? And, can you share your code?

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

This is the Code

a!localVariables(
local!CostData: a!queryEntity(
entity: cons!ERV_dataEntity,
query: a!query(
selection: a!querySelection(
columns: a!queryColumn(field: "totalCost", alias: "Total_Cost")
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(field: "totalCost", operator: "not null"),
a!queryFilter(
field: "rmApproval",
operator: "=",
value: true
)
}
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20)
)
).data,
local!CostData
)

 And see below this is the output and I want to add all the total Cost Value.

List of Dictionary - 7 items

• Dictionary
  • Total_Cost19000(Number (Integer))
• Dictionary
  • Total_Cost18000(Number (Integer))
• Dictionary
  • Total_Cost15000(Number (Integer))
• Dictionary
  • Total_Cost7000(Number (Integer))
• Dictionary
  • Total_Cost9000(Number (Integer))
• Dictionary
  • Total_Cost13000(Number (Integer))
• Dictionary
  • Total_Cost1500(Number (Integer))

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.

a!localVariables(
  local!emailData: a!queryEntity(
    entity: cons!ERV_dataEntity,
    query: a!query(
      selection: a!querySelection(
        columns: a!queryColumn(field: "totalCost", alias: "Total_Cost")
      ),
      logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          a!queryFilter(field: "totalCost", operator: "not null"),
          a!queryFilter(
            field: "rmApproval",
            operator: "=",
            value: true
          )
        }
      ),
      pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20)
    )
  ).data,
  local!emailData
)

a!localVariables(
  local!emailData: a!queryEntity(
    entity: cons!ERV_dataEntity,
    query: a!query(
      selection: a!querySelection(
        columns: a!queryColumn(field: "totalCost", alias: "Total_Cost")
      ),
      logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          a!queryFilter(field: "totalCost", operator: "not null"),
          a!queryFilter(
            field: "rmApproval",
            operator: "=",
            value: true
          )
        }
      ),
      pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20)
    )
  ).data,
  local!emailData
)