Compare Numeric Values

[pravin_bindage]

Look at output panel
386.29<>386.28 Two values not matching but the difference is only 0.01, so how can i ignore this small difference while checking that value is matching or not?
I put three conditions to validate the record other two conditions satisfies but this amount matching condition is not satisfies due to this small difference

[pravin_bindage]

@Anil_G @sangeethaneelavannan1 @Rahul_Unnikrishnan @Gokul001

[Steven_McKeering]

Hi

Have you tried converting to ‘Int32’ which will be a whole number (no decimals) so it will be 386. Then you can compare the two numbers?

Create a new variable called:
int_PortalA (Int32)

Convert the two values to Int32 using an Assign:
int_PortalA = CInt(PortalA)

Then simply compare with an ‘IF’ activity.

Hopefully this helps

Cheers

Steve

[Sudharsan_Ka]

HI @pravin_bindage

Try like @Steven_McKeering suggestion and you can also try to round the both the values and compare

Math.Round(your variable or expression)=Math.Round(your variable or expression)

Regards
Sudharsan

[pravin_bindage]

Math.Round(Convert.ToDouble(CurrentRow(“Claimed tax”).ToString.Trim.Replace(“,”, “.”)), 2) =Math.Round(Convert.ToDouble(in_str_AmountFromPortal.Trim.Replace(“.”, “”).Replace(“,”, “.”)), 2)

i’m using this condition

[Sudharsan_Ka]

Okay Try like this @pravin_bindage

Math.Ceiling(Convert.ToDouble(CurrentRow(“Claimed tax”).ToString.Trim.Replace(“,”, “.”)), 2) =Math.Ceiling(Convert.ToDouble(in_str_AmountFromPortal.Trim.Replace(“.”, “”).Replace(“,”, “.”)), 2)

Regards
Sudharsan

[pravin_bindage]

this error shows when i use Math.Ceiling insted of Math.Round @Sudharsan_Ka

[Sudharsan_Ka]

@pravin_bindage

Remove that “,2” from both the sides and try once

Regards
Sudharsan