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

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

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

pranavk513816

Certified Associate Developer

12 days ago

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_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))

Discussion posts and replies are publicly visible

Top Replies

Mathieu Drouin 12 days ago +2 suggested
Certified Lead Developer

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

Parents

0 Stefan Helzle
Certified Lead Developer
12 days ago

pranavk513816 said:
but it is not working.

What exactly does this mean? And, can you share your code?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 pranavk513816

Certified Associate Developer

11 days ago in reply to Stefan Helzle

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
)

Reply

0 pranavk513816

Certified Associate Developer

11 days ago in reply to Stefan Helzle

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
)

Children

No Data