Filter tool

[jrathod14]

Hi Team,

I need to filter data from a column of excel data source where value is greater than 0 and should consider value of each cell of that column to 6 decimal only.

For example;-

0.123456 - Should be there in "T" bucket of filter tool

0.1234567 - Should be there in "T" bucket of filter tool

0.000000123456 - Should not be in "T" bucket of filter tool as we need value only till 6 decimal

0.000000000123 - Should not be in "T" bucket of filter tool as we need value only till 6 decimal

I have used filter tool [Field 1] > 0 . Please advise how could we filter value with 6 decimal only.

[atcodedog05]

Hi @jrathod14 

Here is how you can do it.

Workflow:

Hope this helps : )

[Luke_C · Accepted solution]

Hi @jrathod14 

Try this:

round([Field1],0.000001)>0

[jrathod14]

This worked.Thank you.

[atcodedog05]

Hi @jrathod14 

I would suggest you not use Round() method because if 7th decimal is greater than 5 it will round up to 1 in 6th decimal and fall in true see below.

This is the main reason I am taking my approach 😅

Hope this helps : )