[Issue]: Audit Report KPI Tab Field Updates

[ClaireValdivia]

Why is this issue important?

On the audit report, in the KPI sheet, the Evidence Based Total Spend field is not pulling from the most recent valid file when it should be.

We also want to review how the fields no. of subawards & no. of expenditures is calculated on the KPI sheet of the audit report as it's likely that we'll want to remove these fields.

Current State

Evidence Based Total Spend seems to be pulling in the value from the first time a value is reported for a project for the field Spending_Allocated_Toward_Evidence_Based_Interventions but it does not update to pull in the value for the project from the most recent valid file

Expected State

On the audit report, in the KPI sheet, the field Evidence Based Total Spend should pull in the value from the most recent valid file for each given project id. The value should reflect what is in the upload file's field Spending_Allocated_Toward_Evidence_Based_Interventions

We also want to review how the fields Number of subawards & Number of expenditures are calculated - unless this is currently doing an aggregate, we’ll want to remove both fields.

Implementation Plan

The following functions need to be added...

Relevant Code Snippets