Rounded to 6 decimal points for clarity

[ntudev]

I'm getting this weird red error that says' Rounded to 6 decimal points for clarity' I don't mind it, but when I join the same field it doesn't join anything with these rounding. Can someone tell me how I can round it and still be able to join without these numbers getting filtered out?

[gautiergodard]

Hey @ntudev 

Sounds like you need to use the round() formula here. You can leverage the below:

round(round([Field1],.0000001),.000001)

The reason I am using 2 round functions embedded in one another is in the event you have 5 in your 6th decimal position, this formula will round up.

Hope this helps!

[DataNath]

@ntudev to further illustrate what's going on here in terms of the join not working, here's a quick example:

Table 1: Value of 1.2345675 - Gets rounded to 1.234568

Table 2: - Value of 1.2345677 - Gets rounded to 1.234568

So if we do a join on [Number]=[Other Number] then we should get a match, right? Well, not here... Whilst the appearance of the number is rounded, the trailing points are still retained for the actual underlying value and so when Alteryx comes to evaluate the join, it's actually comparing the full numbers to one another i.e. 1.2345675 vs 1.2345677 which are obviously different.

So how doe we get round this? Well, as @gautiergodard has suggested, we can enforce actual rounding before the join which will truly round the number to x dp: