Calculate Field Question

Hello All,

I am trying to do a calculated field that will take the average unit price, multiplied by the sum of the units.

My current calculated field is taking the sum of the unit price, multiplied by the sum of the units.

Please help.

Thanks!

You may not perform that calculation in a calculated field because it will always use sum. You may use PowerPivot or simply add a new column to your data with 1 in each row and then modify your calculation to
='Unit rate' / 'new field name' * Units