Formula Tool For Calculating Parameters

davechndr

Good morning!

How are you all doing?

I am super new to Alteryx and am having difficulty with some basic functions. One of them is the Formula Tool (in the dark blue section) for creating formulas from tables entered directly on to the program via the "Text Input" Tool in the Green Section pallete.

If I want to create a formula where a new field is involved (and is being calculated), and this new field is outside the ones that are on the Text Input, how do I create this formula to make it work, so I can tabulate the right values in this new field?

E.g. If I have to calculate the $Sales of an apparel company, and there is no column for "$Sales" in the Text Input Table but I already have input the two columns for Unit Price and Quantity Sold do I have to put a column for $ Sales in the Text Input Table before I calculate it using the Formula Tool?

Any help would be greatly appreciated.

Thank you so much!

Best,

@davechndr

patrick_digan

@davechndr I would go the formula tool route in this case. The formula tool can both add new fields and updating existing fields. You may want to check out the examples by hovering on the formula tool in the tool palette at the top and then click open example:

For your particular example, I've attached a workflow where the $Sales is calculated in the formula tool.

4-27-18.yxmd