I am new to working in Alteryx, and I having an issue figuring out this problem. I want to create a new column, with the results being the values of another column being divided by a fixed value. For example, take this illustration. I would want to create a "Column C" where every Column B value is divided by A2. For excel, it would simply be "=B2/$A$2," but I don't know how to reflect the "dollar sign effect" into my Alteryx formula tool. It simply divided the two columns all the way down, so only my top result is correct, and all the rest are incorrect.
Solved! Go to Solution.
@ScottWW You want the multi-row formula to cascade the data downwards then use the formula tool to create column C with the calculation. Attached is the workflow. Does that help?
hi @ScottWW ,
you can use the multi-row formula to fill in the value in column A and then use a formula to divide
hope this helps!
