Add the the Variable Values inside For each loop and pass it to single variable

[Amol_Golhar]

Dear Team,

I have Values in excel like below

Values
60
18
30
15
40
55
19

I have to check below 20 values, add all those values in single varibale and print it.

For Ex. 18,15,19

Please let me know how to do this.

Thanks,
Amol

[Krishna_Raj]

@Amol_Golhar
Assign activity:
totalSum = 0

Read Range activity:
DataTable = Excel Application Scope → Read Range

For Each Row activity (DataTable):
If activity:
Condition: Convert.ToInt32(row(“Values”)) < 20
Then:
Assign activity:
totalSum = totalSum + Convert.ToInt32(row(“Values”))

Write Line activity:
"Sum of values below 20: " + totalSum

[Nawazish_Ahmad]

Hi @Amol_Golhar

Try this:

(From d In DT.AsEnumerable
 Where Not (isNothing(d("Values")) OrElse String.IsNullOrEmpty(d("Values").ToString.Trim))
 Select v = CDbl(d("Values").ToString.Trim)
).Take(20).Sum(Function(x) Convert.ToDouble(x))

Hope it will helps you
Cheers!!

[FerdinanAlberto]

Read The Excel Sheet
For Each Row Dt
if RowValue < 20
Assign OuputValue= OutputValue+RowValue
Write Line OutputValue

[lrtetala (Lakshman Reddy)]

Hi @Amol_Golhar

Try this

DT.AsEnumerable().Where(Function(row) CInt(row("Values")) < 20).Sum(Function(row) CInt(row("Values")))

Input:

Output:

Cheers!!

[rlgandu (Rajyalakshmi Gandu)]

@Amol_Golhar

Assign activity:
total = dtValues.AsEnumerable().Where(Function(row) Convert.ToInt32(row("Values")) < 20).Sum(Function(row) Convert.ToInt32(row("Values")))

[lrtetala (Lakshman Reddy)]

@Amol_Golhar

If you want

@Amol_Golhar

I have to check below 20 values, add all those values in single varibale and print it.

For Ex. 18,15,19

Try this

String.Join(",", DT.AsEnumerable().Where(Function(row) CInt(row("Values")) < 20).Select(Function(row) row("Values").ToString()))

Cheers!!

[Jayesh_678 (Jayesh)]

Try this:-

string valuesBelow20 = string.Join(“,”, dt.AsEnumerable()
.Where(row => row.Field(“Values”) < 20)
.Select(row => row.Field(“Values”)));