Changing certain number range to 0

[skucharczyk]

Hi all! First post in this community and I'm sure this is a simple fix but im new to Alteryx.

Background: I have an excel that has 4 digit account numbers in 1 column and then an amount in column 2 (example below):

Acct:    Amt:

1234    450.09

3243      40.33

5464      44.09

6477    333.33

Help Needed: I want to add a formula in to the workflow to basically do the following: For any account # greater than 3999, replace the # in the amount column with 0.

So the end product if I was to run an output should show the following:

Acct:    Amt:

1234    450.09

3243      40.33

5464          0

6477          0  

[binuacs · Accepted solution]

@skucharczyk One way of doing this