ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Machine Learning Discussions

Find answers, ask questions, and share expertise about Alteryx Machine Learning.
Getting Started

Start your learning journey with Alteryx Machine Learning Interactive Lessons

Go to Lessons

FORMULA QUESTION

JACKIEC1992
7 - Meteor

What formula would I use if I wanted to take all keywords associated with "AM WI/CO" and divide the Debit number by 3.

 

Same for AM Florida and divide the debit by 3.

1 REPLY 1
johnyli168
Alteryx
Alteryx

Hi Jackie,

See attached screenshot below of what the formula looks like. You would replicate the same for the AM FL title too and just replace the "AM WI/CO" with "AM FL".

johnyli168_0-1658387682317.png