Hi All
I have a situation where I have the following data which has a divisor and multiplier value for each column. I want to calculate each cell value of a column using formula [Row value]\[Divisor]*[Multiplier]. Divisor and Multiplier changes from one column to another. On top number of columns can vary from one data set to other.
For Column 1/1/2020 Row A the calculation should be 1/1*1, Row B will be 2/1*1 and so on. For column 1/2/2020 Row A calculation should be 11/10*5, Row B will be 12/10*5 and so on, Column 1/3/2020 Row A calculation should be 21/5*10, Row B will be 21/5*10 and so on.
| | 1/1/2020 | 1/2/2020 | 1/3/2020 | 1/4/2020 | 1/5/2020 |
| A | 1 | 11 | 21 | 31 | 41 |
| B | 2 | 12 | 22 | 32 | 42 |
| C | 3 | 13 | 23 | 33 | 43 |
| D | 4 | 14 | 24 | 34 | 44 |
| E | 5 | 15 | 25 | 35 | 45 |
| F | 6 | 16 | 26 | 36 | 46 |
| G | 7 | 17 | 27 | 37 | 47 |
| H | 8 | 18 | 28 | 38 | 48 |
| Divisor | 1 | 10 | 5 | 3 | 6 |
| Multiplier | 1 | 5 | 10 | 5 | 7 |
Using the calculation and divisor and multiplier of each column the output should come as shown below:
| | 1/1/2020 | 1/2/2020 | 1/3/2020 | 1/4/2020 | 1/5/2020 |
| A | 1.00 | 5.50 | 42.00 | 51.67 | 47.83 |
| B | 2.00 | 6.00 | 44.00 | 53.33 | 49.00 |
| C | 3.00 | 6.50 | 46.00 | 55.00 | 50.17 |
| D | 4.00 | 7.00 | 48.00 | 56.67 | 51.33 |
| E | 5.00 | 7.50 | 50.00 | 58.33 | 52.50 |
| F | 6.00 | 8.00 | 52.00 | 60.00 | 53.67 |
| G | 7.00 | 8.50 | 54.00 | 61.67 | 54.83 |
| H | 8.00 | 9.00 | 56.00 | 63.33 | 56.00 |
| Divisor | 1 | 10 | 5 | 3 | 6 |
| Multiplier | 1 | 5 | 10 | 5 | 7 |
Any suggestions how to achieve this using Alteryx Designer?
