How to add the SAP amount and Excel Amount

Help Studio
, ,
1

I’m having the excel data with the Ref number:"9002666193"bot need to add the sum of data in the “0-30(TC)” column
excel data

MicrosoftTeams-image (3)
MicrosoftTeams-image (3)1920×2560 529 KB

Sap data is with the Reference number :“9002666193” the column Amount in doc.cur need to be equal to excel sum of data based on the ref number
image

2

Both sum values should be match and regarding the reference number the bot need to click the check mark in SAP

image
image729×360 9.74 KB

3

@Jyothi1

For sum check you can use saptotalvalue.equals(dt.AsEnumerable.Where(function(x) x("ref no").ToString.Equals(requiredrefno)).Sum(function(x) x("0-30(TC)"))

And for click you can extract the data in sap table find the reference number row and then use the sap table cell activity to click by passing the extracted row value

cheers

4

what is the assigned variable need to use
var_amount: saptotalvalue.equals(dt.AsEnumerable.Where(function(x) x(“ref no”).ToString.Equals(requiredrefno)).Sum(function(x) x(“0-30(TC)”))
var_Amount variable type
and also need to find the reference number in sap as well based on that only sap total we can take
how can we take sap total based on reference