HI Team,
We have came across a scenario where we had a defaultValueExpression which is sum the columns in dynamic matrix as below
Code"defaultValueExpression": "sumInArray({question2},'Column 2')"
but the sum calculation is only working for the first time means when no data is patched to survey runner. When data is patched to survey runner if we tried to update the matrix colum's the sum calculation is not reflecting.
I have sample project for reference / to replicate the Scenario
Json for reference
Code{
"logoPosition": "right",
"pages": [
{
"name": "page1",
"elements": [
{
"type": "text",
"name": "question1",
"title": "sum",
"defaultValueExpression": "sumInArray({question2},'Column 2')"
},
{
"type": "matrixdynamic",
"name": "question2",
"title": "matrix",
"columns": [
{
"name": "Column 1"
},
{
"name": "Column 2",
"cellType": "text"
},
{
"name": "Column 3"
}
],
"choices": [
1,
2,
3,
4,
5
]
}
]
}
]
}