Hi @Patrick1,
Your calculated field is calculating the average for each vendor. It should show the same value in all rows that have the same vendor.
If you want to calculate the average across all vendors, try this:
avgOver({per_unit_spend}, [], PRE_AGG)