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.
Solved! Go to Solution.
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)
@Luke_C what should I select in data type, because when i put fixed decimal, its giving all null result
Hi @hf14 I tested this with fixed Decimal set to 19.3 and it worked to add on 3 decimal places see below:
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.