Help formatting a pivot table in Google Sheets

Job ID: 34777809

Budget: $10 – $30 USD

I have a long pivot table in Google Sheets, I need to display the weighted average in 2 of the columns, so I need to apply a custom field formula there, but I have some values with blank spaces and I'm getting errors.
Additionally need to display those 2 columns in %, I also want to highlight the total rows, haven't found a way to do this.
Will award immediately if we can get it fixed right away.
Thank you.
Related categories: Google Sheets Google Spreadsheets