Need to compare 2 numbers if are the same so it "OK" if not "KO"

Help Activities
,
1

The numbers i compare are from an excel file and the other is on SAP, the numbers are the same but at the end the bot think that the numbers are different.

I think its beause once is a text and the second is a number

image
image773×355 13.8 KB

this is the code for the number on excel :

image
image1116×702 45 KB

This is the code for the number in SAP :

image
image1092×653 37.3 KB

2

Hi,

Can you check and share each value of excel and SAP using LogMessage activity etc?
Probably, It’s necessary to convert them to be comparable.

Regards,

3

Hi @Soudios

Try the below way

If Convert.ToInt32(Number1) = Convert.ToInt32(Number2) 
Then
    ' Your logic if numbers are equal
Else
    ' Your logic if numbers are not equal
End If

Hope it helps!!