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
