You can use below in the Filter tool
For greater than 1
[Sum_Sum_FUNCTIONAL_AMOUNT]>=1
For greater than 0.1
[Sum_Sum_FUNCTIONAL_AMOUNT]>=0.1
For greater 0.5 which is rounded to 1
[Sum_Sum_FUNCTIONAL_AMOUNT]>=0.5
Considering only values below 0.5 is rounded to 5 and V
https://help.alteryx.com/current/designer/filter-tool
Hope this helps🙂
Hi @dunkindonut7777 ,
you also could use the ROUND function:
Round([Field1], 0.00001) > 0
Using " 0.00001" should remove all values with rounding to six digits (including 0.000009). By setting the number of digits, you can set the "precision" off the filter tool (e.g. 0.000001 would also keep values >= 0.000005).
Best,
Roland