How to multiply?

How to multiply

I want to multiply the days and the distance.

Hi @helpplease

cdbl(CurrentRow.ByField(“Days”))*cdbl(CurrentRow.ByField(“Distance”))

@helpplease

Hi @helpplease

=> Use read range workbook activity to read the excel and store in to a datatable.
=> Use for each row in datatable activity to iterate each row
=> Take an assign activity inside for each, create a variable called result it will be in double
=> Assign → Result = CDbl(row(“Column1”)) * CDbl(row(“Column2”))
=> You can use the Result variable to pass anywhere.

Check the below workflow for better understanding.

Check the output below, for your reference I write the result in the result column.
image

Hope it helps!!

Use an assign activity where left side is multipliedValue and of type Double and right side is CDbl(currentRows(“Days”))*CDbl(currentRows(“Distance”))

@helpplease
CurrentRow(“Days”).ToString=Var1
Days=Convert.ToInt32(Var1)
CurrentRow(“Distance”).ToString=Var2
Assign: doubleVariable = Convert.ToDouble(Var2)
Days* doubleVariable

Hi @helpplease

Please find the below xaml

BlankProcess4.zip (153.4 KB)

O/P :
Input.xlsx (9.4 KB)

image

I hope it helps!!

@helpplease

If you got the solution for your query. Please mark it as solution to close the loop.

Regards,

How do I use range H1:J4 and write to column K?

@helpplease

I hope it helps!!

Thank you so much!!!

1 Like

Screenshot 2023-07-27 212028
column not found

I changed the header to the date.

I’ve ticked add headers by why does it says column not found?

You can try giving index instead of column name

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.