Formula tool if condition

Question

Hello everyone,

This might be more of a programming/logic question rather than question about the tool. I have a dataset that looks like this:

I need an if condition to give anything greater than $200,000 and ((Time >= 15) or (3 times the Period)) whichever is sooner to output a separate column as exclude. The rest as keep. Let me know if the question is not phrased correctly. Any help in getting to this logic would be highly appreciated. Thank you all great folks at Alteryx Community.

Emil_Kos · Accepted Answer

Hi @murthybhs,

If I understand you correctly you just want to filter out the data that don't meet the criteria mentioned by you.

This is the formula you should use for the filter:

[Amount]>200000 AND ([Period]*3)>[Time] OR [Time]>=15