Calculating weighted average when weight field depends on unit of measurement

[lf7988]

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! 

[Emil_Kos]

Hi @lf7988,

can you kindly show us the expected output? 

[Qiu]

@lf7988 

I guess this is what you mean?