Hi All - Struggling to find a way to calculate a value for a record with a variety of different multiplier values.
My base table is below and I want to calculate the values of each record (Name) in my base table with all combinations of all possible multiplier values. So if the record - "Adam" in my base table has a base value of "1", I want to multiply this value of "1" with all possible combinations of the values for the record "Adam" in all of my multiplier tables.
Base Table:
| Name | Base |
| Adam | 1 |
| Joe | 3 |
| Diane | 4 |
| Jamie | 2 |
| Sam | 5 |
Multiplier tables:
| Name | Multiplier1 - S |
| Adam | 1 |
| Joe | 3 |
| Diane | 3 |
| Jamie | 4 |
| Sam | 2 |
| Name | Multiplier1 - M |
| Adam | 3 |
| Joe | 2 |
| Diane | 4 |
| Jamie | 1 |
| Sam | 5 |
| Name | Multiplier1 - L |
| Adam | 1 |
| Joe | 3 |
| Diane | 3 |
| Jamie | 3 |
| Sam | 1 |
| Name | Multiplier2 - S |
| Adam | 5 |
| Joe | 2 |
| Diane | 1 |
| Jamie | 4 |
| Sam | 6 |
| Name | Multiplier2 - M |
| Adam | 1 |
| Joe | 4 |
| Diane | 4 |
| Jamie | 2 |
| Sam | 2 |
| Name | Multiplier2 - L |
| Adam | 4 |
| Joe | 2 |
| Diane | 2 |
| Jamie | 5 |
| Sam | 6 |
Thank you for your support and help with this!! Really appreciate it!
