=FILTER(Table2[% Move],ABS(Table2[% Move]>2.9%),””)
This is giving me a value error. I am trying to sort the %move column by its absolute value show it shows both negative and positive changes that are greater that 2.9%. Any ideas on how to get the proper output.
=FILTER(Table2[% Move],ABS(Table2[% Move]>2.9%),””)