How to subtract 2 columns

Help Automation Ops
,
1

how to subtract 2 column data and print that in beside column
what is the expression for that?
how to subtract

2

@anjani_priya

For Each row As DataRow In dt.Rows
    row("Result") = Convert.ToDouble(row("Column1")) - Convert.ToDouble(row("Column2"))
3

Subtract.xaml (11.3 KB)
Refer this workflow

4

in which activity should I write this

5

You can use the “Invoke Code” activity
The “Invoke Code” activity allows you to write custom code directly in your workflow.

6

can you send sample code
how to write that after invoke method

7

the values are in double
can you tell how to convert them
Book1.xlsx (8.8 KB)
sample excel

8

Subtract.xaml (9.7 KB)
refer this

9

Capture42
Capture421587Ă—586 24.6 KB

error

10

can u show ur varibale panel

11

Capture43
Capture431352Ă—675 20 KB

12

Hi @anjani_priya

- Read Range (Input: Excel File, Output: DataTable)
- Add Data Column (Name: Result)
- For Each Row (Input: DataTable)
    - Assign (Left: row("Result"), Right: CDbl(row("Amount(in RS)")) - CDbl(row("Closing Debit")))
- Write Range (Input: Modified DataTable, Output: Excel File)

image
image1087Ă—804 58.3 KB

Hope it helps!!

13

image
output

14

Capture42
Capture421587Ă—586 24.6 KB

Capture43
Capture431352Ă—675 20 KB

15

Capture44
error

16

@anjani_priya

BlankProcess4.zip (201.1 KB)
Found Solution in Sequence3.xaml

17

Capture45
Capture451654Ă—738 30.8 KB

error

18

I suggest u to create a workflow and then run the workflow ,i think you r running directly from download

20

how I can I round off the values?

21

can you eloborate your requirement @anjani_priya