Dear Team, How to sum col1 and col2 data and put result in col3 with out using for each in excel

Help Studio
, ,
1

How to sum col1 and col2 data and put the result in col3 with out using each in excel.

2

Hi @Lokesh_M2 ,

What about below workflow

Sum Col1 and Col2, then update Col3

intSum =CDbl(CurrentRow(“Col1”))+CDbl(CurrentRow(“Col2”))

image

Thanks,
Rajkumar

3

Thank u. But i need with out using FOR EACH

4

HI @Lokesh_M2

Try this

image

Regards
Sudharsan

5

Dt is the variable from the read range @Lokesh_M2

6

Hi @Lokesh_M2 ,

add Column as “Col3” in dtTest, then use below expression

> (From SV In dtTest.AsEnumerable()
> Let Col3= If(IsNumeric(SV("Col1").ToString) And IsNumeric(SV("Col2").ToString),CStr(CDbl(SV("Col1").ToString)+CDbl(SV("Col2").ToString)),"NA")
> Select dtTest2.Rows.Add({SV("Col1").ToString,SV("Col2").ToString,Col3.ToString})).Copytodatatable()

image
image1052×565 21.3 KB

Excel.xaml (7.5 KB)

Input
image

Output
image

thanks
Rajkumar

7

option strict on disallows implicit conversions from ‘string’ to ‘long’
Showing above error