Using the same file, create a conditional field that equals $0$ if the Amount field is less than $$1000$ and $1$ if the amount field is greater than or equal to $$1000.$Set a filter and identify how many records have a $"1"$ indicating greater than $$1000$ in amount. How many records did you find?

Hint: Use an IF then statement similar to the asynch. $$Make sure to set your data type to "double".$$