Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Formulas based on specific cells

GraceBerg
5 - Atom

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? 

GraceBerg_0-1666822765053.png

 

3 REPLIES 3
gautiergodard
13 - Pulsar

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)

gautiergodard_0-1666824479332.png

 

Table Tool | Alteryx Help

acarter881
12 - Quasar

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.

 

PangHC
13 - Pulsar

Pang_Hee_Choy_0-1666835530136.png

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.

 

Labels
Top Solution Authors