Pivot Table Calculated Field - Sum of Column A * Min of Column B

I am attempting to divide the sum of one column by the sum of another and then multiply the result by a lookup value. The division part of the equation is irrelevant to my question, but I supplied that information to better explain my workbook. I get the same issue if I am multiplying the sum of a column by the lookup value.

What I need to do, in short, is multiply the sum of a column by a lookup value. However, because I cannot do a lookup in a pivot table, i must do it in my data. This results in duplication of data. I thought to mitigate this by using MIN() (I could have just as easily done Average or Max, as all values within the group will be the same), however it appears that either it is summing the column and then applying MIN, or it is applying MIN to each record and then summing the result.

I have added a "Should Be" column in my workbook and highlighted the field in question, if that helps in any way.

I am trying to understand what you are trying to do but cannot figure it out. I will try to explain how pivots work to a least help you in some way.
(1) Pivot calculations only work directly with the data table, never with the resulting pivot table values.
(2) Pivot calculations work with columns (not rows like excel): So at each step of the way it is working with resulting column data.
(3) Before any calculations is carried out the pivot engine determines the the column result.
(4) To determine each column result, all filters are first applied to the data table.
(5) The "user defined formulas" are finally applied to the cumulative column results.
(6) Steps 3 to 5 are repeated for every single pivot cell.

To see this partially in action go to D4 in the example you posted, then double click.
A new sheet will be inserted containing the detail rows (after applying filters) making up the calculation of D4
Look at this sheet and try to work out the D4 result based on what I described above.

Hope this helps to resolve some of the pivot table mystery. Things start to get even more interesting once you transition to power pivots.

I ended up adding a helper column in my data which I called "CountingColumn" with a value of 1 in all rows. This way when it sums my target modifier I then divide the result by the sum of the counting column, essentially returning me to the value I need by giving me the average in a roundabout way.

Thank you both for trying. I know sometimes figuring out what others are trying to accomplish can be difficult.

I was trying to do something similar and did a lot of brain storming. Thanks for sharing this, it helped a lot.

Thanks for sharing, I was trying to do something similar & the idea with Counting Column really helped.