Hi All,
I have two tables in the same layout where i am trying to multiply them against each other (think 'Table1'C1 multiplied by 'Table2'C1, 'Table1'D1 multiplied by 'Table2'D1, etc.)
Here are two sample data sets that i am trying to calculate with a 'Table1' multiplied by 'Table2'
Table1:
Y1 | Y2 | Y3 | Y4 |
543 | 543 | 543 | 543 |
123 | 123 | 123 | |
765 | 765 | ||
987 |
Table2:
Y1 | Y2 | Y3 | Y4 |
.2 | .1 | .5 | .3 |
.2 | .1 | .5 | |
.2 | .1 | ||
.2 |
@transformationnation
find the workflow attached
mark done if solved.