Access one element within another element

Help Studio
, ,
5

Hi @swathi_sakthi ,

Assuming that these are the Filed Keys of the containers, we can use the below Expression to calculate the Sum from the Different Questions obtained.

Jval("Cnt1").ToObject(Of JObject).Properties.Where(Function(x)x.Name.Contains("q")).Sum(Function(x)CDbl(x.Value))

The above should give you the total marks of the First Container.

Let us know if you are not able to understand the above and let us know if you get any error.

1 Like