Hello all - I am attempting to calculate a weighted average in my flow but the weight field would differ based on unit of measurement. Could anyone help me figure out how I could make this work simply?
See table for example of what I mean. "Value" column would be the value field. But which column was the weight field would depend on the unit of measurement (ounces or packs).
| Value | Unit of Measurement | Annual # of Packs | Annual # of Ounces |
| 3.21 | Ounces | 573 | 27,698 |
| 6.37 | Packs | 71 | 245,896,321 |
| 6.17 | Packs | 4,192 | 2,541,682 |
| 7.75 | Packs | 7,826 | 5,498,230 |
| 1.63 | Ounces | 3,352 | 5,412,369 |
| 8.63 | Packs | 125 | 741,578 |
| 9.79 | Packs | 5,488 | 154,891 |
| 5.22 | Ounces | 14 | 12,639,871 |
Thank you!
