Failing to create an Average Profit column in Pivot Table
I’m using an “Insert Calculation Field” with a formula =AVERAGE(‘Box Office Revenue ($)’) – AVERAGE(‘Budget ($)’). But instead of average I get some strange summarized results
pls explain what is wrong with the logic and why
(https://i.sstatic.net/LhiiwVRd.png)
New contributor
Mikhail Frenklakh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.