Insert Calculated Field where source field is an Average

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Since a PT is involved put your manually calculated results in the columns alongside the PT.

Hi,

You can't do that just with a calculated field, unless you have Power Pivot. What you can do is add another column to the source data (let's call it Cogs Count) that simply returns 1 for each row, and then modify your calculated field formula to
= ((COGS/'COGS count' )-CPA)*Conversions
since COGS/'COGS count' will give you the average.

You're welcome.