Filter Number Value in Field

[karamarburger]

I am trying to filter the number of transactions. If there are <= 200,000 they will have a different unit cost than transactions 200,001 +. Any ideas how I can do this in Alteryx? Thanks in advance.

[Emil_Kos]

Hi @karamarburger,

Maybe you can use a tool called record ID?

It will count each record from the top and you will know when the record ID is higher then 200k you will charge the client more/less.

[karamarburger]

I meant to include this image. I have a count of all transactions in one field. I had to add multiple fields to get the total before I filter it out based on the 200,000 count.