Number not matching, round off issue

[hf14]

I have these numbers data, I just simply want to equate them.

As you can see im getting only 1 result as True, when I know all of them are equal but due to decimal its failing.

I tried round but maybe I dont know how to use.

[Luke_C]

Hi @hf14 

Try this, depending on your tolerance for variances you can add more 0s. The below checks to two decimals and results in all your records matching.

Round([G],.01) = Round([T],.01)

[hf14]

@Luke_C  what should I select in data type, because when i put fixed decimal, its giving all null result

[Luke_C · Accepted solution]

Hi @hf14 

Double should be fine

[hf14 · Accepted solution]

Hi @Luke_C 

Keeping it as double is working but i want numbers with 3 decimal places

[Luke_C · Accepted solution]

Hi @hf14 

See attached workflow. I'm not sure how yours is configured but this is working:

[Deano478]

Hi @hf14 I tested this with fixed Decimal set to 19.3 and it worked to add on 3 decimal places see below:

[hf14]

Thanks @Luke_C 

Now I know why your solution didnt work for me, as I was testing it separately in TextInput but when using it in the original workflow which is using Excel inputs, its working.