Calculating each row of a column with common divisor and multiplier for that column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to help and thank you for the accept mark 😁
