A formula parse error has appeared when I used a formula in the calculated field of pivot table in Google Sheets

Question

I am currently studying Data Analytics by watching YouTube videos uploaded by Google.

I am currently on the part where I am following along the demonstration of the instructor using the Movie_Data dataset.

I encountered the problem when I exactly entered the formula the instructor entered in the calculated field of the pivot table which turned out no problem, but it did not work on my side. The formula in question is:

=SUM(Box_Office_Revenue) / COUNT(Box_Office_Revenue)

The attached screen capture and link detail my current situation.

text

In the rows under the Calculated Field, I expect the value will be the same as in the rows in this image:

enter image description here