Formulas based on specific cells

Question

Hello everyone!

I'm a bit new to Alteryx and was wondering is it possible to create formulas within/based on specific cells like in Excel? For example with this matrix I would like to base my values on the red 8% value (for example have the left be 8%+2% and the left be 8%-2% etc) so when I update the cell the whole table will change with it. Is this possible in Alteryx or should I stick to excel for this type of calculation?

Merit Metrix 4.xlsx

AncientPandaman · Answer

here the screenshot.

suggest do it excel. as when you wait alteryx to fully open. you already finish by excel.

alteryx

1. build a table, the +/- table. left blank in for 0%

2. use formula tool to input percent you want (like 8%)  *for advance use interface tool to link with multiple row tool

3. select tool to remove input column.

excel.

similar concept but using formula.

1. Put 8% in H2 (the input cell)

2. for B2  =H2+2% B3 = H2+3% etc.

acarter881 · Answer

Hello @GraceBerg. I created a workflow that allows you to automate this process. The +- 2% should be set as a user constant (numeric) in Alteryx. The workflow may be shortened, but it does the job of what you're describing in Excel.

mimic excel formulas.yxmd

gautiergodard · Answer

Hey @GraceBerg

You should be able to do with using row and column formulas in the table tool. (contained in the reporting pallet of alteryx)

Table Tool | Alteryx Help