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.
