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?
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)
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.
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.
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |