For the love of formulas...

Alteryx Engine Works Blog Post

In the face of a challenge, I have found that I like choosing the easy route.  The tip that I’m about to share with you is not only easy to implement, but it also is elegant and provides for data governance and simplification of testing.  In this case, the easy method is likely the best method.  The challenge at hand is to take a known set of data (a fixed set of data elements) through a known set of data computations (a fixed set of formulas) to generate a known set of variables.

for more ... please check out the link to the blog.