How to subtract 2 columns

Help Automation Ops
,
22

Hi @anjani_priya

Please find the below attached xaml’s
If you require the decimal values then use the Cdbl as mentioned in main xaml and if you require the output without decimal’s then use Cint as mentioned in sequence xaml
For decimal values

image
image880×903 43.1 KB

For values without decimal’s
image
image880×903 42.8 KB

BlankProcess1.zip (213.7 KB)

Regards

23

while subtracting the values can I round off them?

24

Capture46
iam getting this error

25

Hi @anjani_priya

Try using CLng instead of CInt

Regards

26

ya u can do that …once the subtraction is done …just assign that value to

math.round(valueObtained,1)

1 Like
27

Hi @anjani_priya

Please use the below syntax to get the values without decimals

CLng(CurrentRow("Amount(in RS)").ToString)-CLng(CurrentRow("Closing Debit").ToString)

BlankProcess1.zip (213.9 KB)

image
image880×903 42.9 KB

Book1 (1).xlsx (10.6 KB)

Regards

1 Like
28

I have 6 invokes , first i have to complete 3 invokes after that 4,5,6 should should how to keep that?

29

Hi @anjani_priya

Are you asking about the invoke xaml’s?

Regards

30

yes. invoke Xaml’s .

31

Hi @anjani_priya

Please place the xaml’s in the order they need to be executed

image
image880×1122 58.7 KB

Regards

32

first I want to execute first three in a loop after loop completed it should go to invoke 4 after 5 after 6 ? how to do that?

33

Hi @anjani_priya

First place those 3 invokes within that loop and later place the 4,5,6 outside of that loop.
Please refer the below attached screenshot and also replace the while with the actual loop you wanted to use over there.

image
image880×1348 49.7 KB

Regards

34

the loops are in the body of the invoke i just want to give like first three invokes like 1st 2nd third and 1 st 2 nd third after that it should go to 4,5,6 invokes

35

@anjani_priya

can you share the screenshot please

Regards

36
  1. Open Your Spreadsheet:
  • Imagine it’s like opening a magic book where numbers live.
  1. Select the Cell Where You Want the Result:
  • It’s like pointing to the space where you want the answer to appear.
  1. Type the Formula:
  • Think of this as giving the magic command. For example, if you want to subtract the number in cell A1 from the number in B1, you’d type: =B1-A1.
  1. Press Enter:
  • It’s like telling the magic book to give you the answer. Press Enter, and you’ll see the result in the selected cell.
37

Capture47
Capture47691×764 35 KB

this is the invoke Xaml’s 1,2,3 are interlinked together by loop
after the loop ends it should start at 4 th invoke xaml

38

Hi @anjani_priya

Use the Flow Chart for those three invoke’s that would make you process easy or else place those 3 invoke’s within a loop and give a condition for that loop so that the loop iterates untill the condition is true and once the condition get’s failed then it will end the loop and executes the 4th invoke xaml

Regards

39

how to connect the flowchart for 4,5,6?

Capture48
Capture481302×613 18.4 KB

40

Hi @anjani_priya

Don’t place the 4,5,6 within the Flowchart. Place the 4,5,6 after the flowchart.

Regards

41

Capture49
Capture49700×849 26.4 KB

I have placed like this but again its going inside 4 th