Adding data returned from query entity

Hi santoshd378,

You can simply achieve this like below;

sum(
tointeger(
local!queryResult
)
)

Thank you,
Arun

How to cast from data subset to number?

Hi,

You can use a!queryAggregation on your query Entity

please refer docs.appian.com/.../Query_Recipes.html

Actually query entity returns list of variant, now I need to get the result in such a way that the expression should return the sum of each value in the list of variant.

sum(
tointeger(
index(
rule!getAllNumbers().data,
"COLUMN_NAME",
{}
)
)
)

Use can use tointeger() or todecimal() based upon the type of data your query entity returns.

You can wrap your query entity rule into tointeger and sum like: -
Sum(tointeger(queryentity.data))

or you can also use aggregation function if your query entity returns only single field
Please refer this link docs.appian.com/.../Query_Recipes.html

Hello,

I think you need to wrap a forEach around the list of variant. And use the sum and to integer function as described by Arun below for each item in for each.

Hi Puspendu Pal,

I don't think a!forEach() is required. sum() itself should be fine here.

Thank you,
Arun