Group a data table multiplying and adding

[ilanaribeiro95 (Ilana Ribeiro)]

I need to make a function that adds in the new column “calculate” the formula:
Col1*(1+Col3)*(1+Col2)

[RajKumar_DC (RajKumar Durai)]

Hi @ilanaribeiro95 ,

kindly check below mentioned workflow

Main (2).xaml (12.0 KB)

Thanks,
RajKumar

[ilanaribeiro95 (Ilana Ribeiro)]

Thanks. But…
I wanted a function

[raja.arslankhan (Raja Muhammad Arslan khan)]

@ilanaribeiro95

var_DT.AsEnumerable().ToList().ForEach(Function (r)
r.SetField(“yourColumnName”, r.Field(“Col1”)(1+r.Field("Col3”))(1+r.Field(“Col2”))))

[ilanaribeiro95 (Ilana Ribeiro)]

I tried this:
dt.AsEnumerable().ToList().ForEach(Function (r)r.SetField(“calculo”,r.Field(“col1”)(1+r.Field(“col3”))(1+r.Field(“col2”))))

don’t worked

[Yoichi]

Hi,

@ilanaribeiro95

I wanted a function

If you need function in the datatable, the following might help you.

dt.Columns("calculate").Expression = "col1*(1+col3)*(1+col2)"

If you need excel formula like =A1*(1+C1)*(1+B1), can you share address of the table in the worksheet.

Regards,

[ilanaribeiro95 (Ilana Ribeiro)]


[ilanaribeiro95 (Ilana Ribeiro)]

can you share your flow?

[Yoichi]

Hi,

If your datacolumn is object type, the following might be better.

dt.Columns("calculate").Expression = "Convert(col1,'System.Double')*(1+Convert(col3,'System.Double'))*(1+Convert(col2,'System.Double'))"

Sample20220922-1.zip (2.8 KB)

Regards,

[ilanaribeiro95 (Ilana Ribeiro)]

it worked!!

Thank you!!!