USAID-OHA-SI / fastR

Import COP19/20 FAST ER Tool
Other
0 stars 1 forks source link

Missing values from Intervention tab #9

Closed achafetz closed 5 years ago

achafetz commented 5 years ago

@cwahle's found that DoD values from FY18 were missing even though they existed on the intervention tab. This is also true to TBD mechanisms.

The issue is that these mechanisms only had TOTAL rows with no breakdown by program/program area/beneficiary. TOTAL row are removed with the assumption that all interventions would sum to the TOTAL.

https://github.com/USAID-OHA-SI/fastR/blob/abfec9af82ee7d25f28a30d13e93b3e6634f68e9/R/limit_inter.R#L13-L16

Need to resolve to see how TOTAL row can be included where no interventions exists in a given year.